In the latest version of jqGrid, you can set rowNum to -1 to instruct the grid to always display all rows: rowNum: -1 See the latest jqGrid documentation here. Specifically: Sets how many records we want to view in the grid. This parameter is passed to the url for use by the server routine retrieving … Read more
The following SQL will get you the row count of all tables in a database: CREATE TABLE #counts ( table_name varchar(255), row_count int ) EXEC sp_MSForEachTable @command1=’INSERT #counts (table_name, row_count) SELECT ”?”, COUNT(*) FROM ?’ SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC DROP TABLE #counts The output will be a list of … Read more
SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘{your_db}’; Note from the docs though: For InnoDB tables, the row count is only a rough estimate used in SQL optimization. You’ll need to use COUNT(*) for exact counts (which is more expensive).
Counting rows in big tables is known to be slow in PostgreSQL. The MVCC model requires a full count of live rows for a precise number. There are workarounds to speed this up dramatically if the count does not have to be exact like it seems to be in your case. (Remember that even an … Read more
The count() function in plyr does what you want: library(plyr) count(mydf, “MONTH-YEAR”)