Hi!

I have a database with one table and around 30000 records. When I execute
SELECT id,title,like(title,'%city') as mc FROM m;
sqlite spends around 180 ms to execute, but if I continue to exec same
statement it starts to loose speed.
Using it on a windows.
Same thing with Sqlite 2.8.15 and with Sqlite 3.0.6/3.0.7
Thank you in advance,
Nebojsa

Reply via email to