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 <[email protected]> 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.
