Perhaps the slowdown comes, counting such amount of records. 2012/4/22 Massimo Di Pierro <[email protected]>
> This is the logic in sqlhtml.py SQLFORM.grid > > if paginate and paginate<nrows: > .... > limitby = (paginate*page,paginate*(page+1)) > rows = > dbset.select(left=left,orderby=orderby,limitby=limitby,*table_fields) > > as you can see it does not fetch all rows when paginating, unless there is > a bug I am now aware of. If there is it should be fixed but need to see the > code that is causing the bug. > > Massimo > > > On Sunday, 22 April 2012 11:37:14 UTC-5, Bruce Wade wrote: >> >> The grid is limiting the amount on the page being displayed. however it >> is still querying all the records then creating the pages so you can page >> between them. The query still queries all of the data instead of using >> limits and or ajax. for 50,000 records it takes almost 3-8 seconds to load >> the page. >> >> db.dailyadviews.id.readable = db.dailyadviews.ad_id.readable = >> db.dailyadviews.viewer_id.**readable = db.dailyadviews.accepted.**readable >> = False >> grid = SQLFORM.grid(db.dailyadviews.**ad_id == ad_id, >> create=False, editable=False, deletable=False, details=False, >> args=[ad_id] >> ) >> >> On Sun, Apr 22, 2012 at 9:26 AM, Massimo Di Pierro < >> [email protected]> wrote: >> >>> This is what I do not understand. If the query is done by the grid, it >>> should limit the number of records to the number of records displayed. >>> If that now happening? Are you calling the query outside of the grid? >>> >>> >>> On Sunday, 22 April 2012 11:22:32 UTC-5, Bruce Wade wrote: >>>> >>>> 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/**bruc****elwade<http://ca.linkedin.com/in/brucelwade> >>>>>> http://www.wadecybertech.com >>>>>> http://www.fittraineronline.**co****m<http://www.fittraineronline.com>- >>>>>> Fitness Personal Trainers Online >>>>>> http://www.warplydesigned.com >>>>>> >>>>>> >>>> >>>> >>>> -- >>>> -- >>>> Regards, >>>> Bruce Wade >>>> http://ca.linkedin.com/in/**bruc**elwade<http://ca.linkedin.com/in/brucelwade> >>>> http://www.wadecybertech.com >>>> http://www.fittraineronline.**co**m <http://www.fittraineronline.com>- >>>> Fitness Personal Trainers Online >>>> http://www.warplydesigned.com >>>> >>>> >> >> >> -- >> -- >> 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 >> >> -- http://www.tecnodoc.com.ar
