Re: Large dataset performance

From: jma <junkmailavoid_at_yahoo.com>
Date: 20 Mar 2007 09:23:26 -0700
Message-ID: <1174407806.827066.17940@n76g2000hsh.googlegroups.com>

> 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)?

Hello Jonathan,

I am not sure I got what you mean.... I create a table which has four fields: int,float,float,float. I then enter a loop and write the same stuff all the time. The integer is just the iterator in the for loop.... Received on Tue Mar 20 2007 - 11:23:26 CDT