Unexplainable disk activity after simple select statement

I am trying to export database tables to ascii files for archiving. I basically write straight sql code that will spool the output of a select * from table statement. For each entry, I have to do this 62 times. That is, I have to open, write the output of the select statement, and close the file 62 times for each entry that I process.

The strange thing, the select statement seems to work fairly quickly but then afterwards I have a lot of unexplainable disk activity that is slowing my outputs to a crawl. The larger the output that is generated from the select statement, the longer the stall seems to be.

Any ide what is going on?

Any help would be greatly appreciated.

Matt Heiman
boo_at_deltanet.com Received on Sun Feb 15 1998 - 00:00:00 CST