MATLAB-SQL 2005 ODBC connection very slow
Ältere Kommentare anzeigen
I've recently upgraded to a 64 bit Windows 7 machine. I am running 32 bit MATLAB in order to be able to connect to a SQL 2005 server using an ODBC connection. Using queries written in .m files, my queries take about 10x longer than they used to on my Windows XP machine. I use the Database Connection toolbox for my connection. There have been no changes to the network which the data has to pass through. Any ideas why my new machine is so much slower?
Antworten (1)
Hakon
am 29 Nov. 2011
0 Stimmen
Peter, I have the same issue, with a JDBC driver. Connecting to the db typically takes 150-200ms, until about 10 connection attempts, then it drops rapidly to about 17ms. (I'm sitting "next" to the DB on a 1Gb network).
Did you ever find out what caused this?
Thanks, Hakon
Kategorien
Mehr zu Configure Environment finden Sie in Hilfe-Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!