Re: [sqlite] Improving text search using LIKE '%string to search%'

[Bert Verhees]

Op donderdag 7 oktober 2004 21:50, schreef Patrick Peccatte:
> I use SQLite 2.8.14 for a documentation application which needs a lot of
> text search.
> Text searchs are done using somethink like:
> SELECT * FROM Texts WHERE CurrentText LIKE '%string to search%';
> I use index on every searchable columns.
> Response time are acceptable until about 10 texts stored in database,
> but are very very long with 50 texts in database.
> Is exist any method to improve this kind of search ?
> --
> Patrick Peccatte - Soft Experience

SQLite does not use indices on LIKE operator,

if you want to do text searches, you better create an algoritm to use 
something like %word-list-index%

You can do text searcha t the beginning of a string

select. where text>=" aa" and text<="aa", it finds all words starting with 
aa, and uses indexes

regards
Bert Verhees

[sqlite] Improving text search using LIKE '%string to search%'

[Patrick Peccatte]

I use SQLite 2.8.14 for a documentation application which needs a lot of
text search.
Text searchs are done using somethink like:
SELECT * FROM Texts WHERE CurrentText LIKE '%string to search%';
I use index on every searchable columns.
Response time are acceptable until about 10 texts stored in database,
but are very very long with 50 texts in database.
Is exist any method to improve this kind of search ?
--
Patrick Peccatte - Soft Experience