New version of the test script, run this script in lp:zeitgeist and in
the attached branch, compare the last line of the output, the attached
branch should be about 8-10% faster
** Attachment added: "glob-index-test_v2.py"
Prefix search is not using an index
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in Zeitgeist Framework: In Progress
In the prefix search we are using a 'GLOB' sql-statement, this statement is not
using the index and thus slow, some timings from me running the attached script:
* Database with ~50k events
* ~1% of these event have a subject with uri beginning with 'http://aa'
* searching for all uris beginning with 'http://aa' using the 'GLOB' expression
(what we have now in lp:zeitgeist) takes ~0.03 sec
* changing this query to some (x >= S AND x < T) statement reduces this time to
This is easy to implement (and test) for ascii chars, but as we support unicode
esp. testing seems to be a bit tricky
Mailing list: https://launchpad.net/~zeitgeist
Post to : email@example.com
Unsubscribe : https://launchpad.net/~zeitgeist
More help : https://help.launchpad.net/ListHelp