[sqlite] How to reindex an FTS3 table after changing the tokenizer

I have a FTS3 table that was created with the simple tokenizer. I want to change the tokenizer and reindex the table. Is there a way to change the tokenizer in place and have it reindex with minimal code? Else the other option I was thinking about was dropping the table, re-creating it with the

Re: [sqlite] sqlite3 question

Also what's your journal_mode and synchronous setting? ( http://www.sqlite.org/pragma.html#pragma_synchronous) Depending on how these are set, if your application terminates early, or system crashes, you will likely corrupt your DB. 2010/10/30 Martin Engelschalk >

Re: [sqlite] Multilple tables with the same schema and prepare query performance

tables used by the query. > > > Pavel > > On Fri, Oct 29, 2010 at 11:52 AM, john Papier <johnpap...@gmail.com> > wrote: > > Hi, > > > > I need to create multiple tables all having the same schema. The > > number/names of the tables will by dynamic.

Re: [sqlite] Multilple tables with the same schema and prepare query performance

eed an explcity ORDER BY, which would make the query more expensive. On Fri, Oct 29, 2010 at 9:11 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 29 Oct 2010, at 4:52pm, john Papier wrote: > > > The thing is, I need to keep a cursor to where in the > > table I was las

[sqlite] Multilple tables with the same schema and prepare query performance

Hi, I need to create multiple tables all having the same schema. The number/names of the tables will by dynamic. There would be somewhere in the order of 10 to 100 of these tables. When doing operations on these tables, I want to avoid having to do a prepare_query every time for performance