by martin.matejka@keboola.com If you need to determine no. of rows which you are storing in SAPI or importing to GD, you need to use the Sandbox. But you don't need to do SELECT COUNT(*) for every table you've uploaded to Sandbox. Just use one simple SQL statement: SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'tapi_XXXXX_sand'; To show rows per table: SELECT table_name, table_rows FROM information_schema.tables WHERE information_schema = 'sand_xxx_xxxxx'; To show sizes of tables in MB: SELECT table_name AS `Tables`, round(((data_length + index_length) / 1024 / 1024), 2) AS `Size in MB` FROM informaton_schema.tables WHERE information_schema = 'sand_xxx_xxxxx'; |