1 Reply Latest reply on Aug 21, 2003 9:43 PM by 37476

    ASP and OO4O, performance/scalability

    326272
      I am trying to use OO4O, but my current
      tests show it under performs our current ado COM interface. When
      stress testing our in-house COM hits 400 transactions per minute,
      where as my current tests with OO4O max out at 200 per minute? I have
      tried various database pool settings and when monitoring the database
      the connections don't appear to expand under load? Any ideas, help,
      recommendations would be appreciated. I am also trying to replicate
      the no-cache dynaset settings, trying cint(8) and again get no
      improvements, here are my code snippets:

      global.asa:

      <OBJECT RUNAT=Server SCOPE=Application ID=OraSession
      PROGID="OracleInProcServer.XOraSession"></OBJECT>
      <SCRIPT LANGUAGE=VBScript RUNAT=Server>

      Sub Application_OnStart

      'Get an instance of the Connection Pooling object and create a pool
      of OraDatabase
      OraSession.CreateDatabasePool 20,40,200,"HDEV", "uid/pwd", cint(0)

      End Sub

      Sub Application_OnEnd

      OraSession.destroyDatabasePool

      End Sub


      </SCRIPT>


      asp:

      <%
      Response.Buffer = True

      Dim OraDatabase
      Dim OraDynaset

      Set OraDatabase = OraSession.GetDatabaseFromPool(0)

      OraDynaset = OraDatabase.CreatePLSQLDynaset("Begin OO4O.GetDataCursor
      (:data); end;", "data", cint(0)).GetRows()

      Set OraDatabase = nothing

      Response.Write("<html><head><title>mulptiple context
      test</title></head><body>")
      Response.Write("<h3>Multiple Context Test</h3><table width=400
      border=1>")
      Response.Write("<tr><td>Title</td><td>First Name</td><td>Last
      Name</td><td>Age</td><td>Sex</td></tr>")

      For i = 0 To UBound(OraDynaset, 2)
      Response.Write("<tr><td>"&OraDynaset(0,i)&"</td>")
      Response.Write("<td>"&OraDynaset(1,i)&"</td>")
      Response.Write("<td>"&OraDynaset(2,i)&"</td>")
      Response.Write("<td>"&OraDynaset(3,i)&"</td>")
      Response.Write("<td>"&OraDynaset(4,i)&"</td></tr>")
      Next

      Response.Write("</table></body></html>")
      %>

      All feedback and experiences would be appreciated!!!