Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance question
Message
From
22/07/2002 10:40:27
 
 
To
20/07/2002 19:05:01
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00680632
Message ID:
00681137
Views:
24
>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
Map
View

Click here to load this message in the networking platform