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 - Oracle: Table.getPrimaryKey is slowly
Summary: Oracle: Table.getPrimaryKey is slowly
Status: RESOLVED DUPLICATE of bug 76600
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 8.0
Hardware: PC Other
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-10 11:37 UTC by cstadler
Modified: 2016-03-16 20:02 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***