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
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
2 matches
Mail list logo