Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sp_datatype_info
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Sp_datatype_info
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01197226
Message ID:
01197226
Views:
230
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.
Next
Reply
Map
View

Click here to load this message in the networking platform