On 9 September 2013 14:43, Niphlod wrote:
> if you don't need the grid to search through the table, the moment you
> turn off the search widget you won't get the "performance penalty" of
> creating the dropbox for the IS_IN_DB requirement you have in your models.
>
Of cause yes. Thanks. I forg
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 thin
if you don't need the grid to search through the table, the moment you turn
off the search widget you won't get the "performance penalty" of creating
the dropbox for the IS_IN_DB requirement you have in your models.
On Monday, September 9, 2013 10:24:48 AM UTC+2, Johann Spies wrote:
>
> Thanks A
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.
Fortunately with the possibility (probably (co)created by you) to get a
result of db
> SELECT rresearch.nu, rresearch.ny, rresearch.nc, rresearch.id
>
> FROM rresearch
> WHERE (rresearch.id IS NOT NULL)
> ORDER BY rresearch.nu, rresearch.ny, rresearch.nc, rresearch.id;
>
> 2920.90ms
>
>
The above query is not used for the grid. Rather, it is used to generate a
dropdown list
Hi Johann
I think this is related:
https://groups.google.com/forum/?fromgroups=#!topic/web2py-developers/2SjrZ3AHR1c
Using recursive queries which fetch the whole row (especially with very
wide rows) is a huge DB hit.
My conclusion is that, ideally, web2py should use joins where necessary.
On 4 September 2013 15:34, Massimo Di Pierro wrote:
> Please check with the response.toolbar to see if there is are hidden
> recursive queries.
>
> Thanks! I did not use the 'db stats' function before when debugging and
it seems a useful tool!
Interestingly the difference is the following:
Whe
7 matches
Mail list logo
