Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance
Message
De
08/01/2004 21:05:26
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Performance
Divers
Thread ID:
00865310
Message ID:
00865310
Vues:
60
Hi,

From your experience how much of a speed difference is running a SQL statement with sql passthru (ex: "=SQLEXECT('Select * FROM orders')") or calling a stored procedure with sql passtru (ex: "=SQLEXEC({CALL usp_GetOrders})")) where the SQL Stored procedure contains that select statement? I know the store procedure is faster, my question is how much faster? By the way, the back end is SQL 2000.

Thanks.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform