On Fri, Aug 15, 2008 at 11:19 PM, Noah Hart <[EMAIL PROTECTED]> wrote:
> Greg, I intended that sqlite3 be launched without a filename, so this
> will give a memory based database and disk I/O would not need to be
> considered.
If I remember correctly the default is an "anonymous" disk based
, 2008 2:52 PM
To: [EMAIL PROTECTED]; General Discussion of SQLite Database
Subject: Re: [sqlite] Generic speed testing
Regarding: "On my AMD system the tests seem to be CPU bound."
On that note, I believe the test creates a 625 megabyte database before
deleting most of it and vacu
--- On Fri, 8/15/08, Noah Hart <[EMAIL PROTECTED]> wrote:
From: Noah Hart <[EMAIL PROTECTED]>
Subject: Re: [sqlite] Generic speed testing
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Friday, August 15, 2008, 4:34 PM
Good Poi
Regarding: "On my AMD system the tests seem to be CPU bound."
On that note, I believe the test creates a 625 megabyte database before
deleting most of it and vacuuming down to a tiny size. So I guess
included in the test is not just one's disk speed, but how fast one's
operating system can
--- On Fri, 8/15/08, Noah Hart <[EMAIL PROTECTED]> wrote:
From: Noah Hart <[EMAIL PROTECTED]>
Subject: Re: [sqlite] Generic speed testing
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Friday, August 15, 2008, 4:34 PM
Good Point Ken,
Here is
;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kees Nuyt
Sent: Friday, August 15, 2008 2:03 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Generic speed testing
On Thu, 14 Aug 2008 13:25:56 -0700, you wrote:
>I'm not sure if this wi
On Thu, 14 Aug 2008 13:25:56 -0700, you wrote:
>I'm not sure if this will even be a valid comparison, so your feedback
>and initial numbers are appreciated.
>
>Please reply with your data as follows
(v1.1 without the DROP TABLE TEST1 statement):
sqlite 3.6.0 running on Acer Aspire 9423 under
On Thu, 14 Aug 2008 13:25:56 -0700, you wrote:
>--
>-- A LITTLE CLEANUP BEFORE WE CONTINUE
>--
>
> DROP TABLE TEST1;
I don't think you really want to drop TEST1.
We'll need it later.
--
( Kees Nuyt
)
c[_]
Windows XP SP2, SQLite 3.6.1, Intel T2400
(1.83GHZ) Dual Core, 2Gb RAM, 5000RPM Drive
SQL error near line 112: no such table: TEST1
SQL error near line 127: no such table: TEST1
0|performance.txt,v 1.0|1.0|0|0.0K Rows/Second
1|Trivial Inserts|21.17|10077696|476.0K Rows/Second
2|Trivial
9 matches
Mail list logo