General information
Title:
Disable MetaData re-sending in ADO
When I'm using ADO I noticed in the SQL Profiler stuff like:
SET FMTONLY ON
SELECT MAINKEY FROM STYLES
Fair enough it sends the metadata. But it does this every time
I move next,prevous (on a Server side cursor).
As far as I recall there is no way to disable the sending of
metadata each time. Or is there?
Anyone know if this is planned or if you can add a request for future
ADO versions to do this?
As far as I'm concerned this only needs to happen once when you open the
cursor. Ok maybe a column type changes but we shouldn't do this while the app is runnnig any ways.
I suppose the overhead is minimal or is it?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only