tags:

views:

161

answers:

1
Q: 

Advantages of Sybase's AseClient for ADO.Net 2 over the ODBC driver

We have an ETL process that reads data from a Sybase DB via the ODBC "Adaptive Server Enterprise" driver v12.05

I'm wondering if there any any performance advantages specifically to migrating to the .Net 2 Sybase.AdoNet2.AseClient.dll ?

+2  A: 

I think that it's obvious that the native provider will be faster than the outdated ODBC. Check this for a similar comparison.

gd047  2010-04-19 18:57:10

related questions

In .NET, will empty method calls be optimized out?
Good Resources for Relational Database Design
How to overload std::swap()
What is good server performance monitoring software for Windows?
Unit test execution speed (how many tests per second?)
Has anyone used Jaxer in production?
Replicating load related crashes in non-production environments
ADO.NET Connection Pooling & SQLServer
Has anyone run performance benchmarks comparing LINQ
Best tool for performance testing ASP.NET
Has anybody used Google Performance Tools?
Improving Productivity of my Teams
Scaling multithreaded applications on multicored machines
Is String.Format as efficient as StringBuilder
Faster way to find duplicates conditioned by time
.NET Remoting Speed and VPNs
How much database performance overhead when using LINQ?
CSharpCodeProvider Compilation Performance
C# DataTable Loop Performance
FileHelpers performance
ConfigurationManager.AppSettings Performance Concerns
Why are SYSTEM and taskmgr.exe taking up 100% of my CPU?
Speed Comparisons - Procedural vs. OO in interpreted languages
Anatomy of a "Memory Leak"
Fastest way to get value of pi