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 218890 - Preload database structure for SQL code completion
Summary: Preload database structure for SQL code completion
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 7.3
Hardware: All All
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords: PERFORMANCE
: 219503 220438 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-09-24 09:44 UTC by stefan79
Modified: 2016-10-03 10:01 UTC (History)
8 users (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter: 183297

Attachments
nps snapshot (36.79 KB, application/nps)
2012-09-24 09:44 UTC, stefan79 		Details
nps snapshot (16.35 KB, application/nps)
2012-10-09 14:02 UTC, medeag 		Details
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 stefan79 2012-09-24 09:44:43 UTC 
Build: NetBeans IDE Dev (Build 201209240001)
VM: Java HotSpot(TM) 64-Bit Server VM, 23.3-b01, Java(TM) SE Runtime Environment, 1.7.0_07-b10
OS: Windows 7

User Comments:
stefan79: CodeCompletion at DB-Execute-Window (Informix-Database).



Maximum slowness yet reported was 7069 ms, average is 4922
Comment 1 stefan79 2012-09-24 09:44:50 UTC 
Created attachment 124790 [details]
nps snapshot
Comment 2 Jaroslav Havlin 2012-10-04 08:35:18 UTC 
The slowness was caused by the database or network latency.
The current implementation does not preload structure of all databases and tables for the current connection, because the amount that can be too big (if the structure is complex).
But some preloading should be considered, e.g. loading column names after table name was typed into the SQL command.
Comment 3 Jaroslav Havlin 2012-10-04 08:59:16 UTC 
*** Bug 219503 has been marked as a duplicate of this bug. ***
Comment 4 medeag 2012-10-09 14:02:15 UTC 
Created attachment 125632 [details]
nps snapshot

autocomplete query
Comment 5 Jaroslav Havlin 2012-10-22 09:59:07 UTC 
*** Bug 220438 has been marked as a duplicate of this bug. ***