Re: Large dataset performance

jma 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....

With an index on the integer column? Most likely, that index has to be updated all 3.5 million times, and the reorganization of that is causing the slow down. Is the index on a separate drive from the data (is that even possible in Interbase)?

-- 
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/