best way to handle this in Python

Steven D'Aprano steve+comp.lang.python at
Sat Jul 21 02:43:58 CEST 2012

On Fri, 20 Jul 2012 12:14:30 -0600, Ian Kelly wrote:

> On Fri, Jul 20, 2012 at 4:34 AM, Rita <rmorgan466 at> wrote:
>> Thats an interesting data structure Dennis. I will actually be running
>> this type of query many times preferable in an ad-hoc environment. That
>> makes it tough for sqlite3 since there will be several hundred thousand
>> tuples.
> Several hundred thousand is not an enormous number.  I think you're
> underestimating sqlite3.

A common trap, and not just for sqlite. I frequently have to remind 
people -- including myself -- that what is a lot of data for you may not 
be a lot of data for your computer.


More information about the Python-list mailing list