Dan Kennedy wrote:
>
> Can you make the database available for download? And
> supply the exact query you are using too? I'd like to
> know why this is. Thanks.
>
> Dan.
>
You can find a tarball of the DB file here:
http://www.research.att.com/people/Arizmendi_Iker/geo.db.tgz
This query runs in around 1.2 seconds:
SELECT length(content)
FROM locateme
WHERE locateme MATCH 'newark OR new OR brunswick';
And this one in around 8.5 minutes:
SELECT length(matchinfo(locateme, 'x'))
FROM locateme
WHERE locateme MATCH 'newark OR new OR brunswick';
Thanks!
Iker
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
