Yes it has built in pagination, however some of my grids will return over 500,000+ records which causes query's to be very very very slow. I would rather limit the returned data because the average person is not going to go through all them records or care about them. For example currently there has been around 19 million adviews each of these records contains a rating, however there is no way SQLFORM.grid can handle loading that much data.
For some data I can use a date range however other tables we are not storing a date field so I can not use that process to limit the results. On Sun, Apr 22, 2012 at 9:13 AM, Massimo Di Pierro < [email protected]> wrote: > grid has built-in pagination. Perhaps I do not understand the question. > Can you show us your code? > > > On Sunday, 22 April 2012 10:40:37 UTC-5, Bruce Wade wrote: >> >> Hi, >> >> Is there a way to limit the returned results for the grid? I am finding >> that my site has so much data already that most areas where I am using grid >> are failing <class 'psycopg2.InternalError'> current transaction is >> aborted, commands ignored until end of transaction block >> >> If there is no way to limit the results is there a specific reason why >> this was never included? >> >> -- >> -- >> Regards, >> Bruce Wade >> http://ca.linkedin.com/in/**brucelwade<http://ca.linkedin.com/in/brucelwade> >> http://www.wadecybertech.com >> http://www.fittraineronline.**com <http://www.fittraineronline.com> - >> Fitness Personal Trainers Online >> http://www.warplydesigned.com >> >> -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.fittraineronline.com - Fitness Personal Trainers Online http://www.warplydesigned.com
