PB 12.5
Oracle 12.1
PB driver O9, O10 or ORA
Hello,
It is very slow to open the datasource painter from the datawindow. The more tables are in the datasource, the more it is slow to open the painter. It's very painful.
I can see that PB generates some SELECT statements using Oracle repository, in particular that one is very slow (more than 10 seconds), and it is generated once for every table of the datasource :
SELECT F.CONSTRAINT_NAME,
F.OWNER,
F.R_OWNER,
P.TABLE_NAME,
SYS.ALL_CONS_COLUMNS.COLUMN_NAME,
F.DELETE_RULE
FROM SYS.ALL_CONSTRAINTS F, SYS.ALL_CONS_COLUMNS, SYS.ALL_CONSTRAINTS P
WHERE F.OWNER = 'EFOR'
AND F.TABLE_NAME = 'CRQ2'
AND F.CONSTRAINT_TYPE = 'R'
AND SYS.ALL_CONS_COLUMNS.CONSTRAINT_NAME = F.CONSTRAINT_NAME
AND SYS.ALL_CONS_COLUMNS.TABLE_NAME = 'CRQ2'
AND SYS.ALL_CONS_COLUMNS.OWNER = 'EFOR'
AND P.OWNER = F.R_OWNER
AND P.CONSTRAINT_NAME = F.R_CONSTRAINT_NAME
ORDER BY F.CONSTRAINT_NAME, SYS.ALL_CONS_COLUMNS.POSITION
Oracle Statistics have already been gathered for the sys and fixed objects.
Does anyone know how to fix this ?
Thank you very much.
Pierre
