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.
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.
http://forum.java.sun.com/thread.jspa?threadID=5112781 or recent thread on nbusers labeled 'Visual Pack Hangs' are description of the same problem
Still reproducible, and the UI is frozen until the editor opens.
If 123537 gets implemented this this issue can help with Query Editor startup time
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
What Oracle DB with 1000 tables I can use for verification. I don't have such Oracle DB.
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
Move visualsqleditor subcomponents below visualweb