|
Posted by Chung Leong on 07/30/06 02:08
I was just doing some testing on the SQLServer ODBC driver for
something I was working and I noticed that retrieving rows through the
odbc functions is incredibly slow compare to using the mssql functions.
We're talking about an order of magnitude difference. I wonder if your
script was simply running very slowly and hadn't actually stalled. Try
timing how long it takes to retrieve all rows from a particularly large
table in a couple test scripts, once with ODBC and then with the mssql
functions.
Navigation:
[Reply to this message]
|