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