Performance using parameters

  • agierbolini
  • Topic Author
  • Visitor
  • Visitor
9 years 6 months ago #9852 by agierbolini
Performance using parameters was created by agierbolini
I have a performance issue using parameters in query

SELECT columns From Linkedtable where column = 'value'

Take 1 sec

SELECT columns FROM Linkedtable WHERE column = @parameter

Take about a minute

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #9862 by Moderator
Hi,
would you send the table DDL and any additional information that can help us reproduce the issue? Is the parameter large? How many rows are in the table? Have you tried to run PGNP Profiler and see how different are the message traces?

Please Log in or Create an account to join the conversation.

Time to create page: 0.060 seconds
Powered by Kunena Forum