March 9, 2011 at 7:29 am
We have a Windows server (W) with installed MS SQL2008 R2, also have Linux server (L) with MySQL.
Both servers connected into one network.
On the box W installed MS SQL Management Studio and Toad (to work with remote MySQL databases on L server)
MS SQL Server on W and MySQL on L connected using ODBC (MYODBC5.DLL) and Linked Servers.
Problem:
Simple query ‘SELECT *FROM table _name’ from Toad on computer W against MySQL database on computer L executed in 1 sec.
The same query, but from MS SQL Management Studio runs 30 sec. SET ANSI_NULLS is ON
What could be the problem?
Thanks.
March 9, 2011 at 8:53 am
Is the TOAD query going through the SQL Server linked server to MySQL, or is it directly connecting to the MySQL database? If it's a direct connection, then the answer is probably the distributed transaction coordinator. Search online for MSDTC or "distributed transaction" to learn a bit about that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 9:04 am
Thank you, GSquared.
Yes, Toad has direct connection to the MySQL.
I will take a look at MSDTC.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply