Massimo, if this question was to me, I don't face this situation with web2py yet.
This is my experience, no matter what tools I use. -- Vinicius Assef On Tue, Feb 7, 2012 at 12:51 PM, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > Are you using trunk or stable. I believe there was an optimization in > trunk in this respect but it was not benchmarks. I would like to know > if it makes things better or worse in your case. > > On Feb 7, 7:54 am, Vinicius Assef <vinicius...@gmail.com> wrote: >> Yes, David. That's a point. >> >> But, I'd like to say if somebody needs to retrieve 100k lines through >> a single query in an online application, something sounds bad. >> >> I'm used to work on tables with millions rows. If you don't elaborate >> a good queries and indexes to minimize traffic between db server and >> its client, things go down quickly. >> >> So, I don't think this kink of benchmark has some value to real applications. >> >> -- >> Vinicius Assef. >> >> >> >> >> >> >> >> On Tue, Feb 7, 2012 at 7:56 AM, David Marko <dma...@tiscali.cz> wrote: >> > Yes its known behaviour because using standard DAL query the system has to >> > convert every line into Python object, which is really time consuming for >> > 100K documents.