Re: [sqlite] up to date info on SQLite query optimization?

2008-07-22 Thread M. Fioretti
On Tue, Jul 22, 2008 14:24:38 PM -0400, Igor Tandetnik wrote: > Are you familiar with SQLite full-text search (FTS) extension? No, thanks for the link, will study it. > > - calculation of moving average of a floating field, eg if a table is ... > Any solution in pure SQL is going to be

Re: [sqlite] up to date info on SQLite query optimization?

2008-07-22 Thread Igor Tandetnik
M. Fioretti <[EMAIL PROTECTED]> wrote: > A few examples of the kind of queries I'd > like to (learn how to) optimize first: > > - search of strings in text fields (both sub-words and whole words) Are you familiar with SQLite full-text search (FTS) extension?