My ADO app slows down as I exceed processing 100,000 records
Posted on 2001-06-07
I have a SQL db that has 500,000 records with 11 columns. I'm updating 1 column and the logic is very simple: Read a record, combine 2 columns into 1, and update. The counters fly throught the first 20,000 then it starts to slow down. By the time it hits 100,000 records
it might process 1 record every 10 seconds. At this rate, it'll take a week to finish. Is their some kind of buffer allocation I can do? This is not a complicated process (about 7 lines).