Abandoned wrote: > I'm very confused :( > I try to explain main problem...
That's always a good first step; try to remember that when you start your next thread. > I have a table like this: > id-1 | id-2 | value > 23 24 34 > 56 68 66 > 56 98 32455 > 55 62 655 > 56 28 123 > .... ( 3 millions elements) > > I select where id=56 and 100.000 rows are selecting but this took 2 > second. (very big for my project) > I try cache to speed up this select operation.. > And create a cache table: > id-1 | all > 56 {68:66, 98:32455, 62:655} > > When i select where id 56 i select 1 row and its took 0.09 second but > i must convert text to dictionary.. Before you go on with your odd caching schemes -- is the database properly indexed? Something like CREATE UNIQUE INDEX mytable_id1_id2 ON mytable (id-1, id-2); (actual syntax may differ) might speed up the lookup operation enough that you can do without caching. Peter -- http://mail.python.org/mailman/listinfo/python-list