Your experiment gives you the answer to your question. You are running
the same software and therefore you are measuring the differences in the
disk and disk controller function between the two platforms. Sqlite's
ACID capability is very much dependent upon the disk hardware.
Fabio Durieux Lopes wrote:
Ok, I have a performance problem with SQLITE. First of all I'd like
to say that Ihave searched the archives and other sites too but
didn't find a problem like mine.
Recently I made a software that got records from a remote ORACLE
database, created a local SQLITE database and then inserted those
records in the local database. All worked fine while developing and
testing, but when I moved it to the computer where it should run I
found it was way too slow to create the database. Did some testing
and haven't found network, hard disk or memory problems.
This is my scenario now:
GW0 - 2 32 bit INTEL HyperThreading Processors 1 GB RAM
RED HAT ENTERPRISE 3 kernel 2.4.21-4.ELsmp
Good performance
GW2 - 2 32 bit INTEL Dual core Processors 4 GB RAM
RED HAT ENTERPRISE 4 kernel 2.6.9-5.ELsmp
Poor performance
My software is slow on GW2 but fast on GW0. Same binary.
I have reinstalled sqlite3 on GW2, copied sqlite3 binaries and
libraries from GW0 to GW2 but didn't succeed.
I also made a little test to read records from a text file and
insert in a DB. Same thing, slow on GW2, fast on GW0. Note that I
used the same binary on both computers.
The table I'm using looks like this:
CREATE TABLE name (col1 TEXT, col2 TEXT, col3 TEXT);
and I insert like this:
INSERT INTO name VALUES ('value1', 'value2', 'value3');
I've seen people saying one should use transactions or to bind
variables and some syncronize stuff, but my question is: If I'm using
the same binary on both computers shouldn't I get similar
performances on both computers?
Anyone has any idea of what might be wrong?
Thanks in advance and sorry for the long mail.
--
Fabio Durieux Lopes
Desenvolvimento
Suntech Telecom Solutions
www.suntech.com.br
Office: +55 48 3234 0107
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------