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)
:[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 compile them
> on
> Win32 pl
> -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 version
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
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 ...
I'll
OTECTED]
> 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 something lik
03 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 into db valu
esses. 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 PROTECTED]
Subject: Re: [sq
10 matches
Mail list logo
