[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 n

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 > Hello Lizhe, > > in order for

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

the tables have exactly the same schema, in theory I should > > be able to use the same prepared statement on any one of those tables. > Any > > ideas on if this is possible? > > No, it's not possible, because prepared query contains information > about the tables used by

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

need an explcity ORDER BY, which would make the query more expensive. On Fri, Oct 29, 2010 at 9:11 AM, Simon Slavin 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 last searching, so I can con

[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 reason