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() {

[sqlite] SQLite .NET Wrappers

Hi, all ! Is there any SQLite wrapper to .NET Compact Framework, in C#? Thanx for all! Luciano.

[sqlite] Removes hole's in ROWID

Hi, I have a table 'myData'. I insert 10 records into 'myData'. Now ROWID's = 1,2,3,4,5,6,7,8,9,10 I delete record where ROWID=5 in 'myData' table. Now ROWID's = 1,2,3,4,6,7,8,9,10 ROWID column have a 'hole' at 5. How I can reindex column ROWID, like this: ROWID's = 1,2,3,4,5,6,7,8,9 Thanks

RE: [sqlite] SQLite .NET Wrappers

My company will ship a commercial one in late Dec/ early Jan. It won't be open source but it will be managed C#. Thanks, Allan -Original Message- From: Luciano [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 8:09 AM To: [EMAIL PROTECTED] Subject: [sqlite] SQLite .NET Wrappers

RE: [sqlite] Performance tuning question

Arthur, For pre-compiled execution in SQLite, try using the sqlite_reset() function. It allows you to avoid having to re-compile your SQL every time you execute it. You can use sqlite_create_function() to do the equivalent of "parameterized" queries by creating a function which takes a parameter

[sqlite] case sensitive select

Hello, I know that this topic has been discussed many times but I'm about to change my database structure to solve my pb so I prefer to be sure that this is the good solution. This is my table for the moment... create table Test ( Key INTEGER PRIMARY KEY, Name VARCHAR(260) ); create index

RE: [sqlite] Performance tuning question

Arthur, sqlite_bind and sqlite_reset are part of an "experimental" API in the latest SQLite source code in CVS, but it isn't part of an official release yet. However, I use them, and they work very well. Tim > -Original Message- > From: Arthur Hsu [mailto:[EMAIL PROTECTED] > Sent:

RE: [sqlite] Performance tuning question

The sqlite_bind() function is brand new as far as I can tell from looking at CVS. You would have to get the latest sources. It looks like it would also be simpler to use sqlite_bind() than to use the way I am doing it which is to use sqlite_create_function() and call the function in my sql to get

Re: [sqlite] Performance tuning question

Hello, I managed to download new CVS versions (by hand ...) and compile them on Win32 platform (finally). Following are my test results: Time elapsedADO.NetSQLite 2.8.6SQLite CVS 0 0 0 0 30 7419

RE: [sqlite] Performance tuning question

Say, are you testing inserts? Allan -Original Message- From: Arthur Hsu [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 6:29 PM To: Andrew Shakinovsky; [EMAIL PROTECTED] Subject: Re: [sqlite] Performance tuning question Hello, I managed to download new CVS versions (by hand