MATLAB-SQL 2005 ODBC connection very slow

1 view (last 30 days)
Peter
Peter on 30 May 2011
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?

Answers (1)

Hakon
Hakon on 29 Nov 2011
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

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!