Performance using parameters

[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

[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?