title: ODAC for .NET is slow
body: <p>I have a Microsoft SQL Server 2008 instance and Oracle 10g database installed side by side on the same remote server with the same exact data loaded in each.  </p>
  
  <p>I've written a program to time a simple query which return about 10,000 records (SELECT * FROM TABLE WHERE X=X).  What I'm seeing through this test is Oracle returns anywhere from 4-12 times slower than MSSQL.  I've tested on a LAN connection, remotely through VPN, using ODP.NET4, ODP.NET2, ensuring the proper 32 bit version is installed on a 32 bit operating system, and the same for 64 bit.</p>
  
  <p>My results are always the same in that Oracle is always many times slower than the SQL Server instance.  </p>
  
  <p>I've also tried the same query inside SQL Developer, and this tool retrieves the same recordset much faster.  When I force the tool to retrieve all records it comes through about 20% slower than SQL Server, which would at least be acceptable in my scenario.</p>
  
  <p>Any help is appreciate.  I know there are several similar questions but the answers from these have not helped resolve the problem.</p>
  
  <p>Thanks</p>
  
  <ul>
  <li>From database server: 3s (Oracle) vs 0.6s (SQL Server)</li>
  <li>From somewhere in lan: 22s (Oracle) vs 4s (SQL Server)</li>
  <li>From remote machine through vpn: 54s (Oracle) vs 21s (SQL Developer) vs 13s (SQL Server)</li>
  </ul>
  
  <p><strong>Additional question: Is this the performance hit that you experience in your ODP.NET + SQL Server compliant applications, or am I right to assume that something is wrong?</strong></p>