On Monday, September 9, 2013 4:24:48 AM UTC-4, Johann Spies wrote: > Thanks Anthony. That explains some of the delays when I am using the > grid. As a result of this experience I will try to avoid using it for > queries involving large tables and look at alternatives like Solidtable. >
I think the main problem is just with the grid's search widget, so you can either set searchable=False, create your own search widget, or simply do: db.isi_alt_countrynames.rsc_id.requires = [db.isi_alt_countrynames.rsc_id. requires] to prevent the creation of the massive dropdown list. Otherwise, the grid should be reasonable efficient. Fortunately with the possibility (probably (co)created by you) to get a > result of db.executesql into the 'Row' type it is fairly straigtforward to > SQLTABLE-related stuff in views combined with db.executesql. > I think converting db.executesql results to a Rows object and passing that to SQLTABLE will be roughly equivalent to just using the grid. Anthony -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
