Home » RDBMS Server » Performance Tuning » Power Builder Data window linkage performance
Power Builder Data window linkage performance [message #219712] Thu, 15 February 2007 11:00 Go to next message
afreen
Messages: 2
Registered: February 2007
Location: Hyderabad
Junior Member
Hi,

i have the performance issue while selecting the record in data window which gets the related data in to other data window.
It is taking lot of time to fetch the data in my
power builder 8.0.4 application

It would be very great if you get the solution for this issue...

thank you..

Afreen Shaik

Report message to a moderator

Re: Power Builder Data window linkage performance [message #219759 is a reply to message #219712] Thu, 15 February 2007 19:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
add to initSID.ora file the undocument parameter:
_make_query_faster=true

Report message to a moderator

Re: Power Builder Data window linkage performance [message #219784 is a reply to message #219759] Fri, 16 February 2007 01:26 Go to previous message
afreen
Messages: 2
Registered: February 2007
Location: Hyderabad
Junior Member
Hi Anacedent,

Thank you for your response..

i have the performance issue while selecting the record in data window which gets the related data in to other data window.
It is taking lot of time to fetch the data in my
power builder 8.0.4 application.

Bank end :Oracle
front end : Power Builder tool(forms and reports)

From where i can get initSID.ora file and how to set the parameter because i am new to this technology.
Please help in this regard.

thank you..

Afreen Shaik

Report message to a moderator

Previous Topic: straight sql vs procedural ASAP
Next Topic: DBA_SEGMENTS: Criteria for a DB/Table export
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 04:53:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.