Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored Proc runs slow in VFP
Message
De
24/12/2003 10:17:34
 
 
À
23/12/2003 12:51:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00861404
Message ID:
00861933
Vues:
20
>As I replied in a previous message, I did not mean to put the s=seconds() before the sqlconnect command in the example I typed. It is the sqlexec command that takes the 1.3 seconds.
>In the odbc connection SQL it is set to point to our sql server called SQL. I am currently changing that to be the IP address rather than the name of the server to see if that helps.

If you set it to (local) it will use shared memory, which is the fastest way to access a SQL Server on the same machine. I have a feeling this is what you use when you connect with Query Analyzer.

Or, is this a remote sql machine?

BOb
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform