You need FTS3:
http://www.sqlite.org/cvstrac/wiki?p=FtsUsage
It comes with the command line version of SQLite 3.6
On Mon, Sep 22, 2008 at 8:43 PM, Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Sun, Sep 21, 2008 at 07:50:23PM -0400, Igor Tandetnik wrote:
>
> > > although not always I want
> > > to fetch all that data. Sometimes I would just to count it.
> >
> > Don't call sqlite3_column_*. Just call sqlite3_step in a loop. But
> > again, if you want to get a count of records, you are unlikely to be
> > able to do any better than a statement using count().
>
> I've got a feeling, you know very good SQLite's internals. How do you
> think:
> is it technically possible to implement much faster searching routine for
> all the LIKE queries?
>
> I'm asking, because I've got no idea presently, whether (or not) the limit
> is just the storage ("flat database file"). So, perhaps supposed different
> one's own procedure has to do about the same, as the built-in, and it'll
> take about the same time? I mean: perhaps different approach to the subject
> is just not possible just because of the limits forced by the storage?
> --
> pozdrawiam / regards
>
> Zbigniew Baniewski
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Seun Osewa
http://www.nairaland.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
