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 94430 - Query Editor takes a long time to start up with remote databases
Summary: Query Editor takes a long time to start up with remote databases
Status: VERIFIED FIXED
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: John Baker
URL:
Keywords: PERFORMANCE
Depends on: 123537
Blocks:
  Show dependency tree
 
Reported: 2007-02-05 18:07 UTC by bugbridge
Modified: 2008-11-18 13:08 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description bugbridge 2007-02-05 18:07:32 UTC
Original status: 5-Cause Known; Suggested Status: NEW

Original Target Release: shortfin_dev; Suggested Target Milestone : 5.5


Original submitter: jimdavidson

Description:
Turn on queryeditor logging: -J-Drave.queryeditor=0

Drag/drop a table from the Oracle database on rave-cheetah.  From the new
rowset, open the query editor.

Query editor takes several minutes (!) to start up.  From the log, we can see
that it is loading the metadata (column names) for every table in the database.
 Since there are over 1100, this takes a long time.  

Either this needs to be done in one operation, instead of 1100+, or it needs to
be done lazily.

Evaluation:
See Description.  Need to be smarter about loading metadata.

Evaluation (Entry 2):
This is still a performance issue, but the performance is exactly the same as in
Leopard/Thresher, and this has never been reported by a customer.  Our test
database configuration may be unusual in having so many tables (600-1200), which
is what causes the issue to appear.

We need to be cautious about making changes here, because the current approach
was adopted to address some other, unspecified, problems.

Lowering the priority and severity.
Comment 1 _ rkubacki 2007-05-25 20:04:28 UTC
http://forum.java.sun.com/thread.jspa?threadID=5112781 or recent thread on
nbusers labeled 'Visual Pack Hangs' are description of the same problem
Comment 2 Andrei Badea 2007-10-09 12:49:13 UTC
Still reproducible, and the UI is frozen until the editor opens.
Comment 3 John Baker 2008-01-12 05:40:43 UTC
If 123537 gets implemented this this issue can help with Query Editor startup time
Comment 4 John Baker 2008-03-28 07:27:41 UTC
 QE opened fairly quickly for each of several remote databases I tried.  Possibly other performance fixes helped out.
Also AFAIK, users have not complained.  Will close as fixed
Comment 5 Roman Mostyka 2008-03-28 12:29:36 UTC
What Oracle DB with 1000 tables I can use for verification. I don't have such Oracle DB.
Comment 6 John Baker 2008-03-28 18:28:33 UTC
One of the databases used is the bug tracking system uses Oracle.  However, it's very rare for a user to bind a JSF
component to a dataprovider that has 1000 field keys
Comment 7 Petr Blaha 2008-11-18 13:08:53 UTC
Move visualsqleditor subcomponents below visualweb