>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

In my experience, loading SQL tables thru a VFP remote view is one of the slowest ways to go. A much better is to build a character string to perform the insert and use SQLEXEC() to do it. There is a limit on string length but it is pretty large; we are using this method to load a 77-column table (1324 byte header) and are not running into the limit yet. My last speed test was under two minutes for 7100 records.

If the process has to be stopped and restarted, you will definitely encounter problems with a remote view.

Table indices will also affect import speed.

Lastly, you might want to consider upgrading your server. You'll want more memory than 64Mb. SQL Server performance is greatly affected by available memory, and if at all possible you'll want to have it on a separate server from your domain.