Hi experts,
I have defined an ODBC connection to a SQL Server 2005. I'm executing a stored procedure using the ODBC stage and the performance is really slow (1 row per 3 sec). When i execute the Store Procedure from the MS SQL Server Management Studio the performance is (350 rows / sec)
It seems to be an ODBC configuration problem, but i'm not sure.
Could you, please, help me? Thanks in advance.
Slow performance executing SQL sp using ODBC
Moderators: chulett, rschirm, roy
There's no difference between using SQL and an SP to a job. Does data stream as expected using an ODBC stage and regular SQL? Switching to a SP should make no difference to the driver itself. If this is a new installation or the first time you're working with SQL Server, consider verifying your ODBC driver is compatible to 2005. (I scratch my head because I remember someone in the last few weeks discovering some compatibility problem, I'll search the forum and post back.)
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle