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 164054 - Bugzilla integration is extremely slow with many products
Summary: Bugzilla integration is extremely slow with many products
Status: RESOLVED FIXED
Alias: None
Product: connecteddeveloper
Classification: Unclassified
Component: Bugzilla (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Tomas Stupka
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-04-29 12:26 UTC by tboerkel
Modified: 2009-07-27 09:20 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
ThreadDump during validate (50.53 KB, text/plain)
2009-05-05 13:12 UTC, tboerkel
Details
ThreadDump during opening of first issue (42.83 KB, text/plain)
2009-05-05 13:15 UTC, tboerkel
Details
ThreadDump during opening of third issue (43.75 KB, text/plain)
2009-05-05 13:22 UTC, tboerkel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description tboerkel 2009-04-29 12:26:49 UTC
We have approx. 1200 products with about 50 components and also some lots of milestones etc.

I realize that this is no common use case, but still NB should be able to handle this.

In the Bugzilla connection dialog, even "Validate" takes some minutes. Opening an issue is also very slow.

And, BTW, how do I delete a defined Bugzilla integration?
Comment 1 tboerkel 2009-04-29 12:34:44 UTC
We have also a new version of our Bugzilla DB, where we have much less products and there the integration is much faster.
Comment 2 Tomas Stupka 2009-04-29 12:46:04 UTC
> Opening an issue is also very slow.
see issue #163951

> And, BTW, how do I delete a defined Bugzilla integration?
main menu > window > servises > issue trackers > context menu on a specific tracker > remove

> "Validate" takes some minutes
we should see if there is a way how to make the validate faster

Comment 3 tboerkel 2009-04-29 13:56:29 UTC
With "very slow" opening an issue, I meant like 3 minutes and not several seconds. I think, both validation and opening
is slow because of the many products in our Bugzilla DB.
Comment 4 Tomas Pavek 2009-04-29 16:35:29 UTC
How does it perform in web browser?
Comment 5 tboerkel 2009-04-30 07:37:09 UTC
It's not ultrafast, but it's working OK since 3 years.
Comment 6 Tomas Stupka 2009-05-04 17:03:35 UTC
so what exactly is slow?

1.) opening an issue 
- how much slower is it compared to the web? 
- how do you open the issue?
  - from goto issue in "Find issues"
  - by dbl clicking issue in a queries results table
  - from somewhere else
- ...
 
2.) validate 
- hm, i've tried an remote repository with cca 500 products and and it took not even 10s...
- any chance to provide some thread dumps

3.) anything else?


Comment 7 tboerkel 2009-05-05 13:00:53 UTC
1.
Web takes 4 seconds, NB takes minutes.
Opening an issue by ctrl-click on an issue number in a source code comment.

2.
I will try to produce a thread dump during validate.
Comment 8 Tomas Stupka 2009-05-05 13:10:44 UTC
> 1.
> Web takes 4 seconds, NB takes minutes.
> Opening an issue by ctrl-click on an issue number in a source code comment.
- for the first time this happens the repository configuration has to be retrieved from the server - this might take
some time. How does it behave when you try it for a second time for a different issue?
- that part was recently tuned in scope of issue #163951 (rev 2231d645abeb)
- how does it perform when e.g. dbl-clicking an issue in the "find issues" dialog?


Comment 9 tboerkel 2009-05-05 13:12:06 UTC
Created attachment 81536 [details]
ThreadDump during validate
Comment 10 tboerkel 2009-05-05 13:15:54 UTC
Created attachment 81537 [details]
ThreadDump during opening of first issue
Comment 11 tboerkel 2009-05-05 13:22:17 UTC
Created attachment 81543 [details]
ThreadDump during opening of third issue
Comment 12 tboerkel 2009-05-05 13:28:14 UTC
Opening the 2nd and 3rd issue by ctrl-click in the source is as slow as the first. NB even freezes completely during
"opening". Attached 2 more thread dumps.

Using the Find issues UI is OK. Searching is fast enough and double-click on an issue opens the issue fast enough.

So, it is only validating the connection and opening an issue by ctrl-click in the source.
Comment 13 Tomas Stupka 2009-05-05 13:34:07 UTC
> Opening the 2nd and 3rd issue by ctrl-click in the source is as slow as the first. NB even freezes completely during
> "opening". Attached 2 more thread dumps.
what build do you have? 
Comment 14 tboerkel 2009-05-05 14:14:49 UTC
NetBeans IDE 6.7 Beta (Build 200904242137)
Comment 15 Tomas Stupka 2009-05-06 22:17:10 UTC
validate - the bugzilla connector libraries we use in netbeans were updated after beta. The implementation should be
faster. 

open issue - as already mentioned - this problem was addressed in issue #163951 and partialy fixed in rev 2231d645abeb. 

the first time an issue is to be opened for an issue tracker (e.g. hyperlinked from code comment) the relevant
repository configuration data has to be retrieved first - this part should be faster now.
changeset   : 130414:4bb1ea110ff2
author      : Tomas Stupka <tstupka@netbeans.org>
date        : Wed May 06 23:12:40 CEST 2009

Note that after the repository configuration was downloaded, each following hyperlink should work significantly faster.


Comment 16 tboerkel 2009-05-07 07:29:18 UTC
Re: "Note that after the repository configuration was downloaded, each following hyperlink should work significantly
faster."

Does this apply to 6.7 Beta also? Because this is definitely not the case.
Comment 17 Quality Engineering 2009-05-07 19:14:38 UTC
Integrated into 'main-golden', will be available in build *200905071401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/4bb1ea110ff2
User: Tomas Stupka <tstupka@netbeans.org>
Log: #164054 - Bugzilla integration is extremely slow with many products
Comment 18 tboerkel 2009-05-11 08:02:47 UTC
I am testing Build 200905101401. Validating is still slow (more than 2 minutes). CTRL-click however is fast now.
Comment 19 Tomas Stupka 2009-05-11 17:32:35 UTC
> I am testing Build 200905101401. Validating is still slow (more than 2 minutes).
i've tried it for a few remote repositories (one has over 1500 projects) and the response time was definitely shorter
then 2 minutes. All that nb does on that action is to call the validate command on the conector libraries we use so i'm
afraid there isn't much we could do at this point...