I understand that memory, disk and processor all play a part in the
speed test results.
However, I am looking for some benchmarks that would give ballpark
figures for the results.
Are people willing to post their speed test results, along with OS, CPU
speed and Memory characteristics?"
Such as
SQLite 3.6.1 running under "Vista 32 bit, 2.4GHz, 3G ram, 5000rpmDisk"
speed1-insert1... 326279489 uS 10.8195909732183 row/s
..
speed2-insert1... 326279489 uS 10.8195909732183 row/s
...
speed3-1.incrvacuum... 326279489 uS 10.8195909732183 row/s
...
speed4-join1... 326279489 uS 10.8195909732183 row/s
etc
My goal is to create tables, similar to the following:
Numbers in Rows per second
(Assuming > 1GB Ram, and reasonable disk)
Unix 32bit
CPU 1GHz 2Ghz 3Ghz
Delete 8 9 10
Insert 10k 20k 25k
Join
Sub-selects
Triggers
Views
Windows Vista 32bit
CPU 1GHz 2Ghz 3Ghz
Delete 8 9 10
Insert 10k 20k 25k
Join
Sub-selects
Triggers
Views
Windows Vista 64bit
CPU 1GHz 2Ghz 3Ghz
Delete 8 9 10
Insert 10k 20k 25k
Join
Sub-selects
Triggers
Views
Windows XP 32bit
CPU 1GHz 2Ghz 3Ghz
Delete 8 9 10
Insert 10k 20k 25k
Join
Sub-selects
Triggers
Views
Regards, Noah
CONFIDENTIALITY NOTICE:
This message may contain confidential and/or privileged information. If you are
not the addressee or authorized to receive this for the addressee, you must not
use, copy, disclose, or take any action based on this message or any
information herein. If you have received this message in error, please advise
the sender immediately by reply e-mail and delete this message. Thank you for
your cooperation.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
