Information générale
Titre:
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?
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