This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 252907

Summary:	Oracle: Table.getPrimaryKey is slowly
Product:	db	Reporter:	cstadler
Component:	DB schema	Assignee:	Libor Fischmeistr <lfischmeistr>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	P3
Version:	8.0
Hardware:	PC
OS:	Other
Issue Type:	DEFECT	Exception Reporter:

Description cstadler 2015-06-10 11:37:53 UTC

We use Oracle 12c and want to get ale the primary keys from each Table in a loop.

For this org.netbeans.modules.db.metadata.model.api.Table#getPrimaryKey is used

This may take roundabout 120-150ms per Table. Not fast but reliable.
When we set the parameter 'includeSynonyms' to true then its costs roundabout 800ms per Table. This is very slowly.

Via direct JDBC-Connection it costs with parameter roundabout 180ms per Table.
Is it possible to do it faster in Netbeans ?

Comment 1 matthias42 2016-03-16 20:02:32 UTC


*** This bug has been marked as a duplicate of bug 76600 ***