Skip to Content
avatar image
Former Member

PowerBuilder performance issue?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 23, 2014 at 12:13 PM

    Hi Mike;

       Does your application use Dynamic DataWindow's perhaps?

    Regards ...Chris

    Add comment
    10|10000 characters needed characters exceeded

    • 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?

  • avatar image
    Former Member
    Dec 23, 2014 at 08:44 PM

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

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

    Stuart

    Add comment
    10|10000 characters needed characters exceeded