Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance question
Message
De
22/07/2002 10:40:27
 
 
À
20/07/2002 19:05:01
Peter Wagner
Point Informática Ltda.
Limeira, Brésil
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00680632
Message ID:
00681137
Vues:
23
>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
Fil
Voir

Click here to load this message in the networking platform