Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.
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
- Posts: 2
- Joined: Wed Dec 12, 2012 6:42 pm
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?
- Site Admin
- Posts: 354
- Joined: Wed Oct 29, 2008 11:27 pm
Return to SQL Server/DTS/SSIS/Linked servers/Replication
Who is online
Users browsing this forum: Majestic-12 [Bot] and 1 guest