Re: Large dataset performance
From: Cimode <cimode_at_hotmail.com>
Date: 20 Mar 2007 10:32:42 -0700
Message-ID: <1174411962.297386.289870_at_n59g2000hsh.googlegroups.com>
Date: 20 Mar 2007 10:32:42 -0700
Message-ID: <1174411962.297386.289870_at_n59g2000hsh.googlegroups.com>
On 20 mar, 16:39, "jma" <junkmailav..._at_yahoo.com> wrote:
<<I would like your opinion and experience on the performance of
writing
large datasets. I am writing in one loop about 3.5 million rows where
each row is an integer and 3 doubles to an Interbase db. All in all
it's about 100MB. My time measurement was 210 seconds. Is this normal?
To me it appears as a veeerryyy long time.... >>
The principle reason I see is the *Looping* algirythmics which is not
what a db does best. I suggest you learn better the power of set
operation through a better mastery of good ol SQL...Hope this helps...
>
Received on Tue Mar 20 2007 - 18:32:42 CET