开发者

.Net Data Access integration with Teradata 12.0

开发者 https://www.devze.com 2023-01-20 22:19 出处:网络
I have am working on a .net application that integrates with a Teradata database version 12. Currently, we are using Odbc at the DAL to interface with the database.

I have am working on a .net application that integrates with a Teradata database version 12. Currently, we are using Odbc at the DAL to interface with the database.

Teradata have come ou开发者_Go百科t with the .Net Managed provider recently. I was wondering if there are any performance benchmarks available to compare ODBC with the .Net Managed provider. Does anyone know (from experience) if we are likely to see any significant performance gain by switching to the .Net Managed Provider for Teradata?

Any insights are highly appreciated!

Regards

AC


You can find a comparison between the use of the .Net provider and the ODBC driver returning 40,000 rows from a data dictionary table here: What's new in Teradata SQL Assistant 13.10 Edition 2

From what the article shows there is a noticeable improvement in performance. Of course your mileage may vary. :)

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号