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
: 219503 220438 (view as bug list)
Depends on:
Reported: 2012-09-24 09:44 UTC by stefan79
Modified: 2016-10-03 10:01 UTC (History)
8 users (show)

See Also:
Exception Reporter: 183297

nps snapshot (36.79 KB, application/nps)
2012-09-24 09:44 UTC, stefan79
nps snapshot (16.35 KB, application/nps)
2012-10-09 14:02 UTC, medeag

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. ***