>I´m new using SQL server.
>
>I have a 20,000 records VFP cursor and I need to insert it into a SQL 2000 table
>
>Actually I´m using a table's remote view and I use "append from dbf('MyCursor')
>
>but it woks very slowly
>
>Is there a better option?
>
>TIA
>
>Carlos Restrepo
You can try either ADO or SQL-passthrough and a stored procedure on the server to insert the rows. ADO with the OLEDB provider will have a slight edge over SPT.
The key here is the use of a stored procedure, due to SQL's ability to have a precompiled execution plan.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only