General information
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
Previous
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