GadFly - MemoryError
Oleg Broytmann
phd at sun.med.ru
Sat Apr 3 09:35:10 EST 1999
Hello!
I tried to add yeat another database backend to my project "Bookmarks
database". My database contains now about 3000 URLs, not too much, I think.
I subclass by BookmarksParser to parse bookmarks.html into gadfly database
and got a database of 500 Kbytes - very small database, I hope.
Then I tried to find duplicates (there are duplicates). I ran the query:
SELECT b1.rec_no, b2.rec_no, b1.URL
FROM bookmarks b1, bookmarks b2
WHERE b1.URL = b2.URL
AND b1.rec_no < b2.rec_no
GadFly eats all memory and fails with MemoryError. Is it that gadfly
really constructs multiplication of b1 and b2, thus getting 3000*3000
pairs? Or I just did something wrong?
I tried to create indicies, but this was not of any help.
BTW, where are indicies stored? After creating ones I didn't find
additional files - only one file in the database changed.
Oleg.
----
Oleg Broytmann National Research Surgery Centre http://sun.med.ru/~phd/
Programmers don't die, they just GOSUB without RETURN.
More information about the Python-list
mailing list