1 Reply Latest reply: Oct 23, 2013 2:27 AM by Filip_Kinsky RSS

    ODP.NET Managed - poor 64bit performance

    Filip_Kinsky

      I started to use the managed ADO.NET provider (august release version 121010 or 4.121.1.0), but I quickly spotted some severe performance issues when running this provider under 64bit process. It behaves quite acceptable when running 32bit process, but I get around 50% lower performance under 64bits. Is this any known issue or is there any solution to such problem?

       

      I got duration around 0.6s when running following code under 32bit environment and around 1.5s when running under 64bit:

                  var sw = Stopwatch.StartNew();

                  using (var conn = new OracleConnection(ConnectionString))

                  {

                      conn.Open();

       

       

                      for (var i = 0; i < 100; i++)

                      {

                          using (var cmd = conn.CreateCommand())

                          {

                              cmd.CommandText = "select sysdate from dual";

                              var result = Convert.ToDateTime(cmd.ExecuteScalar());

                          }

                      }

                  }

       

       

                  Console.Out.WriteLine(sw.Elapsed);