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 137010 - adding column blocks awt
Summary: adding column blocks awt
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords: PERFORMANCE
Depends on:
Blocks:
 
Reported: 2008-06-11 15:57 UTC by Tomas Stupka
Modified: 2008-07-22 15:50 UTC (History)
1 user (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 Tomas Stupka 2008-06-11 15:57:06 UTC
Select a db table in the explorer and try to add column via context menu 'Add Column...'. 
The IDE gets blocked for the whole time the column is being added to the table. 
Quite annoying.

The same for 'Add Index...'
Comment 1 David Vancouvering 2008-06-16 22:34:43 UTC
Wow, this is hard to test because it happens so quickly with a local server.  What setup did you have that makes it take
so long to add a column?

I'll see if I can jigger the code to see if it actually blocks the IDE.

I'm not sure if this is a P2 because (a) this is the first time a user has complained about it, and this is a common
feature and (b) for most use cases adding a column is so fast as to be unnoticeable.

Please explain why you think this should be a P2.
Comment 2 Andrei Badea 2008-06-17 12:53:43 UTC
It seems Create Table suffers from the same problem. We need to fix this in all dialogs by adding a progress bar. I
don't think it is doable for M1.
Comment 3 Tomas Stupka 2008-06-17 13:37:42 UTC
> Wow, this is hard to test because it happens so quickly with a local server.  What setup did you have that makes it 
> take so long to add a column?
a local mysql table, a few hundred thousand rows

> I'll see if I can jigger the code to see if it actually blocks the IDE.
just create yourself a huge table, shouldn't be a big deal

> (a) this is the first time a user has complained about it, and this is a common feature and
well, to me it happened the first time i used it:). the ide hung for minutes and i wasn't able to do anything

> (b) for most use cases adding a column is so fast as to be unnoticeable.
my guess is that every time you change a bigger tables structure you will get long answer times. Even if it is not a
frequent usecase, i don't see a justification for blocking awt by an remote call.

> Please explain why you think this should be a P2.
see http://qa.netbeans.org/bugzilla/bug_priority_guidelines.html
- AWT thread blocked by a task which could run on background
- No or inappropriate indication of progress of a running task 

Comment 4 Andrei Badea 2008-07-21 14:16:32 UTC
6077ce56ce2f
Comment 5 Roman Mostyka 2008-07-22 15:50:29 UTC
Verified with build 080722.
It works for me. If it is reproducible for somebody, please feel free to reopen this issue.
Thanks.