info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
fmtonly
13 views
Skip to first unread message
Yakov Y
Jan 29, 2014, 3:16:41 PM1/29/14
to
I have a very weird situation with one of the sp.
when I create it and try to rub it takes about 10 min to execute,
BUT! If before executing i ran set fmtonly on then set fmtonly off It execute within 2-6 seconds.
As far as I know fmtonly to sp is the same as noexec to query.
What does it do that makes sp to run that much faster?
What can i do so sp will run faster without fmtonly????
Any help is greatly appreciated!
Adaptive Server Enterprise/15.5/EBF 17795 SMP ESD#1/P/x86_64/Enterprise Linux/asear155/2495/64-bit/FBO/
Edit/Delete Message
when I create it and try to rub it takes about 10 min to execute,
BUT! If before executing i ran set fmtonly on then set fmtonly off It execute within 2-6 seconds.
As far as I know fmtonly to sp is the same as noexec to query.
What does it do that makes sp to run that much faster?
What can i do so sp will run faster without fmtonly????
Any help is greatly appreciated!
Adaptive Server Enterprise/15.5/EBF 17795 SMP ESD#1/P/x86_64/Enterprise Linux/asear155/2495/64-bit/FBO/
Edit/Delete Message
0 new messages