RE: [sqlite] In-memory DB performance tuning

r, I need multicolumns and I need more sophiscated feature like > ORDER BY and GROUP BY. > > -Arthur > > -Original Message- > From: Steve Dekorte [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2003 10:38 PM > To: Arthur C. Hsu > Cc: [EMAIL PROTECTED] > S

RE: [sqlite] In-memory DB performance tuning

Yes I know the Berkeley DB or gdbm solutions out there. However, I need multicolumns and I need more sophiscated feature like ORDER BY and GROUP BY. -Arthur -Original Message- From: Steve Dekorte [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 10:38 PM To: Arthur C. Hsu Cc

[sqlite] In-memory DB performance tuning

Hello, I have an in-memory DB and try to perform inserts to tables inside. Seems that there are some performance bottlenecks for continuous inserts. The row insertion speed will drop dramatically after the first 6000 rows are inserted. That is Time ElapsedRows inserted Ro

RE: [sqlite] Performance tuning question

Okay maybe you guys didn't follow up my previous mails. I give a brief intro again. I'm using SQLite in my program, and I have 2 threads. One thread performs insert, and the other thread perform update. The number below is the table showing that how many rows are inserted in given time. I expe

RE: [sqlite] Performance tuning question

Hello Greg, The insert is not in transaction. I do the insert and update like CCriticalSection cs; void CDB::insert() { cs.Lock(); sqlite_exec_printf(pDB, "insert into db values(%d, %q, null, null, 0, null", 0, 0, 1, "A"); cs.Unlock(); } void CDB::update() { cs