By large datasets I mean a database of which one of the tables contain more than 42 million records.
Using SQLFORM.grid on such a dataset is very slow because the process wants to count the total number of records. I am using Postgresql. I can get an estimated size of the table by replacing count(*) with # SELECT reltuples::integer FROM pg_class WHERE oid = 'isi.ritem'::regclass; reltuples ----------- 42183232 (1 row) And I get the result in a fraction of a second. When working on such a scale the exact number of rows (count is also not always accurate on an active database) is not a necessity. Is there a way I can replace the count(*) in the grid with the query illustrated above? Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
