>I have tried loading data for first time on SQL server 6.5.
>The NT4 server was PII 350mhz with 64 mb ram as domain server and sql server. The terminal or client was a AMD k6 450 mhz with 128 mb ram with win 98.
>
>I tried to add 38000 records from a vfp table to remote view of sql server. It took about 35 mins to complete the task.
>
>What is wrong in above process.
>
>Rajesh

Factors which can affect the speed.

1. Speed of Network
2. Record Header Size
3. Buffer Mode
4. Batch Update property

Bye
Jayesh