Not sure, but 10K or 15K.
On 26 Oct 2007 at 12:39, John Stanton wrote:
> What are the rotational speeds of the disks?
>
> Fabio Durieux Lopes wrote:
> > 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]
> > -----------------------------------------------------------------------------
> >
>
>
> -----------------------------------------------------------------------------
> 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]
-----------------------------------------------------------------------------
