PowerBuilder performance issue?

[Former Member]

Hello all,

we have a PowerBuilder application and we have noticed a performance issue. It seems that the following SQL statement is called continuously and it causes severe delays and performance impact:

SELECT SYS.ALL_CONS_COLUMNS.COLUMN_NAME, SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME FROM

SYS.ALL_CONSTRAINTS,SYS.ALL_CONS_COLUMNS WHERE  SYS.ALL_CONSTRAINTS.CONSTRAINT_TYPE ='P' AND

SYS.ALL_CONSTRAINTS.TABLE_NAME = 'OLRIVI' AND    SYS.ALL_CONSTRAINTS.OWNER = 'XYZ' AND

SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME = SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME AND

SYS.ALL_CONSTRAINTS.TABLE_NAME = SYS.ALL_CONS_COLUMNS.TABLE_NAME AND    SYS.ALL_CONSTRAINTS.OWNER =

SYS.ALL_CONS_COLUMNS.OWNER ORDER BY

SYS.ALL_CONSTRAINTS.CONSTRAINT_NAME,SYS.ALL_CONS_COLUMNS.POSITION

The database versions are 10g and 11g. Any ideas, how to cache, speedup or turn off the statement?

Thanks in advance,

Mika

[Former Member]

Possibly your retrievals are fetching the result-set descriptions and types.

Check the "StaticBind" database parameter from the help ( Connection Reference > Database Parameters ).

Stuart

[Former Member]

Hi Mike;

   Does your application use Dynamic DataWindow's perhaps?

Regards ...Chris

[Former Member]

Hi,

and thanks for your comment. We don't use Dynamic Datawindow's. About staticbind option; does it goes to Pb.ini -file?