>>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?
Hi,
Just try to do it with SCAN .. ENSCAN. and insert/commit each row at a time.
See the difference and please get back to me with the results.
Bye
Jayesh
- Jayesh