Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sp_datatype_info
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Sp_datatype_info
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Divers
Thread ID:
01197226
Message ID:
01197226
Vues:
229
Hello,

In VFP 9 SP1, everytime we issue an SqlConnect() or an SQLStringConnect() i see in SQL profiler (for both SQL server 2000 and 2005) the following:
select USER_NAME() select usertype,type,name from systypes where usertype>=257
select USER_NAME() select usertype,type,name from systypes where usertype>=257
exec sp_datatype_info 1
go
exec sp_datatype_info 12
go
exec sp_datatype_info -2
go
exec sp_datatype_info -3
go
In VFP8 only the first 2 line are present. It is hurting performance on our application (VFP9 SP1 dll's under COM+ application)

Anyone know how to avoid the 4 calls to "sp_datatype_info"

Thanks.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform