best way to handle this in Python

[Steven D'Aprano]

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

> On Fri, Jul 20, 2012 at 4:34 AM, Rita <rmorgan466 at gmail.com> 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.




-- 
Steven