Re: Large dataset performance

> 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 - 17:23:26 CET