Home » Infrastructure » Windows » OO4O - sluggish performance (*occational)
icon9.gif  OO4O - sluggish performance (*occational) [message #136239] Tue, 06 September 2005 20:06
NEOLLE_
Messages: 6
Registered: September 2005
Location: Davao Philippines
Junior Member
Hi,
Im recently using OO4O. Most of my applications in the past are done using ADO. After reading tons of documentations of OO4O,-- (i even bought a book), I really want to go for it.
I have a new application that is 100% OO4O.

I noticed that,(- specially upon first query-) My program takes a looonggg time before it returns a result Mad . Sometimes its so fast Cool .
I read that OO4O uses soft parse when intialised.. but the time it took to initialise is aweful.

I use REF cursors a lot:
sSql = "BEGIN " & _
            "   custinfo.custdetails (:mParam,:mParam2,:mSearchKey,:mRec); " & _
            "END;"
Set mdynCust = mOraDatabase.CreatePlsqlDynaset(sSql, "mRec", ORADYN_ORAMODE)

    mdynCust.Refresh

and only issue a
mdynCust.Refresh
whenever a new parameter is supplied.

How can I enhace its performance?
Any tips you could recommend?
Please...

Thanks
Previous Topic: Can't connect developer 6i with oracle 9i on windows xp
Next Topic: Excel-Oracle Connectivity Problem
Goto Forum:
  


Current Time: Thu Mar 28 10:17:13 CDT 2024