> Almost every day of the week files will be coming in that need to
> processed.
> They are all CSV formatted. They can contain anywhere from 100-1000000
> records. I would have to say that about 750,000 records per week is the
> average. The size of each record is averaged about 200 bytes (see the end
> of the post). It is being moved into a single table with 2 or 3
> indexes on
> it. ( All of the tests being performed were with 10 varchar(30)
> fields with
> no indexes, triggers, generators, or constraints)
>

Ed, you are trying to move 200Mb down the wire - what bandwidth are you
using on the test case and what bandwidth do you have at the real site?
Alan