>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement