Reply to Re: insert into linked server problem

Your name:

Reply:


Posted by AlterEgo on 03/06/07 17:22

kundze,

Distributed transactions across servers are substantially slower than
similar transactions executed on the same server. Assuming your servers are
both SQL Servers with the same collation settings, turn on the "Collation
Compatible" parameter in the Server Options tab of the Linked Server
Properties dialog. This could help somewhat.

Have you checked the other common performance issues such as indexes, etc.?

-- Bill


"kuNDze" <kundze@gmail.com> wrote in message
news:1173171140.944958.149290@p10g2000cwp.googlegroups.com...
> hi,
>
> on localServer i execute this query
>
> INSERT INTO table (A, B, C)
> SELECT A, B, C FROM LinkedServer.myDB.dbo.table
>
> everything is fine. But if i execute this one
>
> INSERT INTO LinkedServer.myDB.dbo.table (A, B, C)
> SELECT A, B, C FROM table
>
> it is very slow. Is there any solution to make it any faster?
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация