February 23, 2012 at 8:42 am
HI
My queries runs much faster on MS Access using ODBC connection to Db2 compare to SQL Server OLE DB connection to Db2 . Is there any solution to run queries (simple select query) faster on sql server through ole db connection to db2 ?
February 23, 2012 at 10:11 am
SAS.DHRUV (2/23/2012)
My queries runs much faster on MS Access using ODBC connection to Db2 compare to SQL Server OLE DB connection to Db2 . Is there any solution to run queries (simple select query) faster on sql server through ole db connection to db2 ?
Too many factors for a forum straight answer; please check link next where Charles Ezzell did a great job addressing this particular performance issue http://blogs.msdn.com/b/hispss/archive/2009/05/18/performance-testing-the-microsoft-ole-db-provider-for-db2-part-1.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply