[sqlite] fts table insert performance

2007-11-18 Thread Wang Yun
Hi I insert rfc txt files into a full text search table, 4119 txt files are 188MB totally. After insert, database file is 443MB. Logic is below, it's not the real code. BEGIN_TRANSACTION CREATE TABLE Notes ( rowid INTEGER PRIMARY KEY, docid, CreateTime, LastModifyTim

Re: [sqlite] fts table insert performance

2007-12-04 Thread Scott Hess
Sorry for the delayed response. Was waiting for time to dig into this a little. Nov 18, 2007 2:05 AM Wang Yun <[EMAIL PROTECTED]>: > I insert rfc txt files into a full text search table, 4119 txt files are > 188MB totally. After insert, database file is 443MB. > Logic is below, it's not the real