Re: [sqlite] FTS2 Experiences?

[John Stanton]

We have just started to use it.  So far it is performing well, but we 
have not subjected it to high volume and large data sets yet.


I have written a simple function which helps in our application.  The 
function concanenates columns to produce a block of text then strips out 
punctuation and prepositions etc and upshifts the case.  The resulting 
string of words is used to create the FTS2 index.  Search strings go 
through the same function.  The FTS2 index is maintained by triggers and 
is transparent to the applications thanks to the user function.


Russell Leighton wrote:


Could folks that have used fts2 in production apps/systems relate their 
experiences to the group?


I would very much be interested in how folks are using it, how well it 
performs with large data and general impressions.


Thanks in advance.

Russ


- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] FTS2 Experiences?

[Jos van den Oever]

2007/6/18, Russell Leighton <[EMAIL PROTECTED]>:

Could folks that have used fts2 in production apps/systems relate their
experiences to the group?

I would very much be interested in how folks are using it, how well it
performs with large data and general impressions.


I had a look at it for an desktop search app, but the fact that you
must have data + index and cannot have only the index, made the db too
large. So I'm hoping for a version where you can use only the index.

As an alternative, I' might use clucene + virtual tables.

Cheers,
Jos

-
To unsubscribe, send email to [EMAIL PROTECTED]
-