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
databa
BEGIN;
> INSERT INTO TIMER (TestNumber, Description, StartTime) SELECT
> 1+MAX(TESTNUMBER), 'Updates with calculations and longer rows',
> (julianday('now') - 2440587.5)*86400 FROM TIMER;
> UPDATE TEST1 SET I=I*1+2-3;
> COMMIT;
> UPDATE
, 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
H
Ken
--- 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"
Date: Friday, August 15, 2008, 4:34 PM
Good Point Ken,
Here is version 1.2 with the mis
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 allo
--- 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"
Date: Friday, August 15, 2008, 4:34 PM
Good Point Ken,
Here is version 1.2 with the missing CREA
-
-- REPORT THE RESULTS
Select TestNumber, Description, ROUND(EndTime- StartTime,2),
Rows, Round(Rows/(EndTime-StartTime)/1000)||'K Rows/Second' from TIMER;
-Original Message-
Fro
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
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 Selects|1.6
Ubuntu 7.10, SQLite 3.5.9 (debugging turned on), Intel Pentium E2140
(1.60GHz) Dual Core, 2Gb RAM, 7200RPM Drive
SQL error near line 111: no such table: TEST1
SQL error near line 126: no such table: TEST1
0|performance.txt,v 1.0|1.0|0|0.0K Rows/Second
1|Trivial Inserts|21.56|10077696|468.0K Rows/
Linux: Sqlite 3.5.9, AMD x64 3800 (2ghz) dual core, 2gb RAM, 7200rpm drive.
SQL error near line 100: no such table: TEST1
SQL error near line 115: no such table: TEST1
TestNumber|Description|ROUND(EndTime-
StartTime,2)|Rows|Round(Rows/(EndTime-StartTime)/1000)||'K Rows/Second'
0|performance.txt,
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 num
13 matches
Mail list logo