Slow response with Bind vars in SqlServer

General discussion forum about all databases other than SqlBase.
FRBhote
India
Posts: 2176
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Slow response with Bind vars in SqlServer

Post by FRBhote » 24 Sep 2012, 15:09

When we use bind variables and query MS SqlServer, the time taken is enormous. With constants, the result is immediate.

Is there some setting to be done to increase the speed?

Jeff Luther

Re: Slow response with Bind vars in SqlServer

Post by Jeff Luther » 28 Sep 2012, 01:06

Need to have you quantify "enormous" a bit closer. "bind variables" -- how many in the WHERE clause? There's no 'setting' that I know of (TD has to so symbol lookups for each), but a sample query and some metrics might give some clue as to the issue.

FRBhote
India
Posts: 2176
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Re: Slow response with Bind vars in SqlServer

Post by FRBhote » 29 Sep 2012, 06:11

Forced Parameterization did the trick

http://technet.microsoft.com/en-us/libr ... .105).aspx

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests