Information générale
Forum:
Microsoft SQL Server
>Bob,
>my Ideia is to call SP in SQL Server using SPT because it's faster than Remote Views.
>My friend told me that making this I wont get the benefit of the execution plan in
>SQL Server memory.
I don't understand that. The main reason to use SP's is because the execution plan has already been determined.
>The friend told me It would be faster using MS Biztalk Ochestration,
>so it would be much faster than with VFP.
I don't see how going through all those extra layers via COM would be faster than talking to the server directly, granted via ODBC.
BOb
Précédent
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