OraFAQ Forum: Windows » OO4O - sluggish performance (*occational)

Home » Infrastructure » Windows » OO4O - sluggish performance (*occational)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 03:21:27 CST 2024