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 76600

Summary:	Don't use DatabaseMetadata
Product:	db	Reporter:	kovica <kovica>
Component:	DB schema	Assignee:	Libor Fischmeistr <lfischmeistr>
Status:	NEW ---
Severity:	blocker	CC:	cstadler
Priority:	P2
Version:	5.x
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:

Description kovica 2006-05-19 10:46:14 UTC

I know from my own experience that using DatabaseMetadata to retrieve informatin
about database, tables, primary keys, ... is VERY VERY slow. At least with DB2.
I suggest that you read those information by querying system catalog. I know
that DatabaseMetadata is the standard way, BUT the performance would be 10x
better, if not more. So supporting databases with thousends of tables would not
be a problem anymore (look at issue 76063).
I'm willing to help.

Comment 1 Andrei Badea 2006-05-19 13:38:01 UTC

Thank you for the offer to help. I will let you know when I start to work on the
dbschema replacement again.

Comment 2 Jiri Rechtacek 2009-10-16 14:08:15 UTC

Reassigned to new owner.

Comment 3 matthias42 2013-05-18 21:32:24 UTC

This should be filed against the JDBC drivers at the vendors bug tracking system. If there is a fast way to retrieve database metadata and the driver does not use it, an application should not work around this defiancy (IMHO).

The JDBC driver abstracts access to the database metadata, removing this abstraction will make life painful. You will need to write code for each DBMS and probably do work-arounds for version specific quirks.

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

*** Bug 252907 has been marked as a duplicate of this bug. ***