>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement