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

Summary:	Preload database structure for SQL code completion
Product:	db	Reporter:	stefan79 <stefan79>
Component:	SQL Editor	Assignee:	Libor Fischmeistr <lfischmeistr>
Status:	NEW ---
Severity:	normal	CC:	athompson, azapeta, brettryan, lolo_101, medeag, mklaehn, musilt2, wfrancootero
Priority:	P3	Keywords:	PERFORMANCE
Version:	7.3
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:	183297
Attachments:	nps snapshot nps snapshot

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