How can I speed up my inserting into SQL Server from VFP?
I have tried creating and calling a remote stored procedure to do the insert but this goes the same speed as VFP inserting into a remote view. About one second per row. I have a test table of two and a half MILLION rows!!! The final version will need to insert between five and fifty thousand rows per day in a single transaction. I am fairly new to SQL Server (recently done the Implementation course). BTW, I am using 6.5 at the moment.
Many thanks,