in reply to Re: processing slows way down
in thread processing slows way down

Thank you for responding.

I ran one 32,000 line input file in about an hour. I ran another 32,000 line input file right after also in about an hour, without rebuilding indexes.

If what you suggest were true wouldn't each time an input file was loaded, without rebuilding the indexes it should get progressively slower?

Replies are listed 'Best First'.
Re^3: processing slows way down
by CountZero (Bishop) on Jul 12, 2004 at 15:33 UTC
    Not necessarily in such a way that one would see it easily. If you have a database with a million records and you first add 32,000 records and then again 32,000 records, the time-difference between the two runs is probably too small to notice.

    CountZero

    "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law