OO4O: Migrating Application Using Oracle Objects for OLE (OO4O) From Windows XP To Windows 7 Shows Performance Degradation When Using CreateObject() (Doc ID 1400095.1)

Last updated on OCTOBER 21, 2013

Applies to:

Oracle Objects for OLE - Version 8.1.7.0 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Oct-2013***

Symptoms

Migrating Application Using Oracle Objects for OLE (OO4O) From Windows XP To Windows 7 Shows Massive Performance Degradation When Using CreateObject() like

Module Module1

    Dim OraSession As OracleInProcServer.OraSession
    Dim start_time As DateTime
    Dim stop_time As DateTime
    Dim elapsed_time As TimeSpan
    Dim iter As Integer
    Sub Main()
        Try
            iter = 10
            start_time = Now
            For i = 1 To iter
              OraSession = CreateObject("OracleInProcServer.XOraSession")
            Next i
                stop_time = Now
                elapsed_time = stop_time.Subtract(start_time)
                Console.WriteLine((elapsed_time.TotalMilliseconds / iter).ToString + " millisecs per iter")
        Catch ex As Exception
            Console.WriteLine("Error: " + ex.ToString())
        End Try
        Console.ReadKey()
    End Sub

End Module

Changes

Upgrading Operating System from Windows XP 32bit  to Windows 7 64bit

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms