I have to amend my last message. The timings I just gave was for looking
up that word 10 times, not 1. So the longest time I've seen would be
about 150 ms. However, if you have a document with a few thousand words
we would still be looking at a significant total searching time. Is this
to be expected?
Kind regards,
Philip Bennefall
On 7/23/2014 11:57 PM, Philip Bennefall wrote:
Hi all,
I have been running some tests with spellfix using a table containing
about 300000 words, extracted from the Moby project's single word list
as well as names and places. Moby can be found at:
http://icon.shef.ac.uk/Moby/
I have noticed that searching for medium length to very long words is
very fast, but when I start searching for short words like "hi" and
"bye", the search time skyrockets. I think the longest search time was
about 1500 milliseconds (the average is somewhere around the 500 ms
mark). My table is set up as follows:
create virtual table if not exists dictionary using
spellfix1(edit_cost_table=editcosts);
When searching, I specify top=5 to get these timings.
Is there anything I can tweak to speed up the search for short words, or
is there anything that can be done by the developers to optimize this
further?
Kind regards,
Philip Bennefall
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
