 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
takakou
Joined: 27 Jan 2009
Posts: 22
Country: Japan |
|
 SQL Server: Using linkserver Stored compile is very slow |
 |
My project use about 30 Link server synonyms.
When I compiled stored procedure, result message elapsed time under 1 sec, but SQL Editor is busy about 1 min.
During SQL Editor is busy, Database execute sql for link server.
I checked by windows task manager.
May be SA try to refresh cash via link server.
But refresh area seems too big...
|
|
| Tue Jun 12, 2018 9:24 pm |
   |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
You should disable automatic cache refresh in this situation, which is performed after all DDL operations including ALTER PROCEDURE. This certainly slows down all thing in a setup like yours. The easiest way to do that is to uncheck the Auto-refresh checkbox in the Database Explorer pane (top-right corner). This works for the current instance of the SQL Editor.
To force manual refresh, click the Refresh icon next to the checkbox.
|
|
| Wed Jun 13, 2018 2:39 am |
|
|
takakou
Joined: 27 Jan 2009
Posts: 22
Country: Japan |
|
| |
|
 |
|
You should disable automatic cache refresh in this situation |
Yes. It's nice!
Thank you
|
|
| Tue Jun 19, 2018 9:28 pm |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
