MATLAB-SQL 2005 ODBC connection very slow
1 view (last 30 days)
Show older comments
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?
0 Comments
Answers (1)
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
0 Comments
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!