[web2py] Re: Smartgrid link very slow.

2019-04-23 Thread dgmanns
I discovered why my smartgrid (and grids) were very slow. = I had neglected to set searchable=False, sortable=False. With those options disabled (I need neither), performance is very good. It is the searchable option that is very costly. It would probably be good to highlight this in the docume

[web2py] Re: Smartgrid link very slow.

2019-04-16 Thread David Manns
The problem is with SQLFORM.grid Table Affiliations has some 5,000 rows. Each row has references to 2 other tables, Members and Colleges each of which has format=... so it displays text rather than the id as a number. So SQLFORM.grid(db.Affiliations.Member==, will correctly display only t