[web2py] Re: Database performance

Good to know. The difference between {{rows = dataSet.select()}} and {{rows = db.executesql(dataSet._select())}} is that the former calls the function "parse" which loops over the 175K rows and converts them into objects. On Aug 26, 12:08 am, HughBarker wrote: > Thanks for the reply. > > {{row

[web2py] Re: Database performance

Thanks for the reply. {{rows = db.executesql(dataSet._select())}} executes in 0.16s. On Aug 26, 2:09 pm, Massimo Di Pierro wrote: > Try by replacing > >  {{rows = dataSet.select()}} > > with > >  {{rows = db.executesql(dataSet._select())}} > > and tell me what get. > > Anyway, your raw sql selec

[web2py] Re: Database performance

Try by replacing {{rows = dataSet.select()}} with {{rows = db.executesql(dataSet._select())}} and tell me what get. Anyway, your raw sql select is only feting a third of the rows that that web2py is fetching. web2py is also doing a lot of extra work converting the list of records from tuples