Hmmm, let me see, both machines are DELL machines and with very
similar specs. If any, I'd say that the new hardware should run
faster. And the performance problem is way slower. GW0 runs for 8
minutes, while GW2 was running it for 30 minutes when I decided to
interrupt it.
I also made a littleprogram that would read my text file an then
copy it to another file. As I expected it did instantaneously (on
GW2). The text file is around 3MB. I also used linux "dd" to create a
1 GB file and I didn't take too long. Any test I should do to check
if I have a HD problem? I used a software from DELL to search for
hardware problems and didn't find anything.
Thanks!
On 26 Oct 2007 at 12:01, John Stanton wrote:
> 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]
> -----------------------------------------------------------------------------
--
Fabio Durieux Lopes
Desenvolvimento
Suntech Telecom Solutions
www.suntech.com.br
Office: +55 48 3234 0107
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
