Edwin A. Epstein, III wrote:

>>>First, no professional programmer would ever send 7 million records
>>>across a network to a client application,...
>
> Welllll. Not 7 million records across the network but between 100K and 2
> million records across the network. I don't really see that I have a
> choice. I have to export those records one way or another for processing. I
> am using a 100 mbit network and a machine right next to the server to obtain
> these records. I am up for suggestions on the fastest way.

Sorry, I got up on the wrong side of the bed.

Does the program that does the further processing need information from
the database other than the record it's currently processing? If not,
would it make sense to write those records to an external table, process
them producing another file, and reimport the data? Can the processing
be moved into stored procedures? If not, could the reprocessing program
run on the server system using local-loopback?

Regards,


Ann