Hi,
Trying to keep this a little alive :)
I ran a SA-independent benchmark, which was simply using a .dump (which
outputs BEGIN TRANSACTION, CREATE TABLE, INSERT ..., COMMIT) of a single
table with 5 columns, ca. 17000 rows:
with BEGIN TRANSACTION/COMMIT:
PRAGMA synchronous=OFF;
real0m1
Michael Parker wrote:
On a stable system with working backup routines running SQLite with
'PRAGMA SYNCHRONOUS=OFF' for bayes makes a lot of sense.
It has been awhile, but I believe you just need to do this at create
time, so you'd only need a proper .sql file that did it.
I think that might
Jonas Eckerman wrote:
> Jakob Hirsch wrote:
>
>> I don't think SQLite itself is _that_ slow (in fact, I don't think it's
>> slow at all), it's most probably a matter of optimization,
>
> SQL Lite *can* be very slow at some inserts/updates on some systems
> because of how it handles writes. SQLite
Jonas Eckerman wrote:
>> If time permits, I'll do a benchmark run, anyway,
>
> Are there any ready made benchmark scripts for the bayes stuff?
Yes:
http://wiki.apache.org/spamassassin/BayesBenchmark
It's got a link to the tarball with the code/scripts in it. (Note: I've
never used them but I do
