zeitgeist team mailing list archive
-
zeitgeist team
-
Mailing list archive
-
Message #00231
[Bug 386946] Re: Slow inserting
I marked this bug as "Fix released" - insertion is relatively fast on
the querymancer backend. It can probably be at least twice as fast, but
I don't see that it is worthwhile shooting a lot of time after that
right now. Query time is a lot more important.
** Changed in: zeitgeist/0.3
Status: New => Fix Released
** Changed in: zeitgeist
Status: In Progress => Fix Released
--
Slow inserting
https://bugs.launchpad.net/bugs/386946
You received this bug notification because you are a member of
Zeitgeist-Engine, which is the registrant for Zeitgeist Engine.
Status in Zeitgeist Engine: Fix Released
Status in Zeitgeist Engine 0.3 series: Fix Released
Bug description:
An average of 2.5 seconds per 200 entries is unacceptable
Creating database... sqlite:stormtest.sqlite
Starting Zeitgeist service...
Updating database with new Documents items
>>>>>> Inserted 1 items in 0.0431048870087s
>>>>>> Inserted 32 items in 0.398054122925s
Updating database with new Images items
>>>>>> Inserted 1 items in 0.0422050952911s
>>>>>> Inserted 200 items in 2.46073818207s
>>>>>> Inserted 200 items in 2.48012709618s
>>>>>> Inserted 200 items in 2.60040402412s
>>>>>> Inserted 56 items in 0.773358106613s
Updating database with new Music items
Updating database with new Other items
>>>>>> Inserted 1 items in 0.0687749385834s
>>>>>> Inserted 14 items in 0.209239006042s
Updating database with new Videos items
>>>>>> Inserted 1 items in 0.0551328659058s
>>>>>> Inserted 2 items in 0.0482969284058s
Updating database with new Development items
>>>>>> Inserted 1 items in 0.0713491439819s
>>>>>> Inserted 44 items in 0.594656944275s