>>Hello Chritopher,
>>
>> I would sugget you to use Remote Views table buffering enabled. First add all
>>records to the view and then update them using single TABLEUPDATE().
>>
>> This will reduce the number of transcation to the server as it write to it just in one shot.
>
>Ok, did that. The only catch was that it took about 20 minutes to do 25000 records. ACK! Any other suggestions before I take the route of optimizing the server?
It's really common to drop all the tables, insert the new data, and then recreate the indexes. How long does it take to create the indexes now.
Also remember that, no matter how many pieces you break it into, a five pound rock still weighs five pounds.
-Mike