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
database
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
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[_]
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 MS
: [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 will even be a valid comparison, so your
--- 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 version 1.2 with the missing CREATE
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 version 1.2 with the missing CREATE
, 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 vacuuming down
After looking at the code for speed test #1-4, I've decided that a
command line version that does not use TCL would be better. Wanting to
keep things simple, I'm looking only at inserts, selections and deletes.
I'm not sure if this will even be a valid comparison, so your feedback
and initial
10 matches
Mail list logo
