Try with bigger cache size.
I think ADO uses bigger cache so it can work longer only
in memory. Transactions can help, but in case of many
updates/inserts there is not enought space in cache, so
the rows are stored on disk.
--
Regards
Michal Zaborowski (TeXXaS)
http://sqlite4delphi.sourceforge.n
Are you doing the inserts in a transaction? That makes a big difference.
On Nov 15, 2003, at 4:59 PM, Arthur C. Hsu wrote:
If you guys has ideas about how could I tune the SQLite to make it
linear,
thank you I really appreciated.
---
From: Bert Verhees [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 15, 2003 2:52 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Performance tuning question
On 14 Nov 2003 at 16:28, Arthur Hsu wrote:
> Hello,
>
> I managed to download new CVS versions (by hand ...) and compi
qlite
> -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 ve
On 14 Nov 2003 at 16:28, Arthur Hsu wrote:
> 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
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
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 5
AIL PROTECTED]
Subject: Re: [sqlite] Performance tuning question
Hello Andrew,
I'm a little confused about the precompiled SQL. According to Wiki, there
should be something like sqlite_bind() that I can use. However, I can't
find sqlite_bind() in my sqlite source ...
IL PROTECTED]
> Sent: Friday, November 14, 2003 2:04 PM
> To: Andrew Shakinovsky; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Performance tuning question
>
>
> Hello Andrew,
>
> I'm a little confused about the precompiled SQL. According
> to Wiki, there should be som
riginal Message -
From: "Andrew Shakinovsky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 14, 2003 7:24 AM
Subject: RE: [sqlite] Performance tuning question
> Arthur,
> For pre-compiled execution in SQLite, try using the sqlite_reset()
func
3:50 AM
To: 'Greg Obleshchuk'; [EMAIL PROTECTED]
Subject: 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 in
ese are just guesses. I'm trying to dig out why. Maybe you guys who are
more familiar with sqlite internals can show me the answer :)
Regards,
Arthur
-Original Message-
From: Greg Obleshchuk [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 8:43 PM
To: [EMAIL PROTECT
qlite] Performance tuning question
Hello,
I'm new to sqlite and I'm using it in my MFC program. I compiled the sqlite
lib myself. I'm using in-memory DB. My program has two threads, say thread
A and B. Thread A is the producer, which inserts rows inside a table named
Hello,
I'm new to sqlite and I'm using it in my MFC program. I compiled the sqlite
lib myself. I'm using in-memory DB. My program has two threads, say thread
A and B. Thread A is the producer, which inserts rows inside a table named
'master'. Thread B is a consumer, which selects and updates
14 matches
Mail list logo