Change Log takes 50 seconds to render
Hello,
We have a Gemini instance (3.5.3 Build 2390) that has about 1200 issues. When we click on 'All Issues' it takes about three seconds. When we click on 'Change Log', however, it takes 50 seconds to render. The change log spans ten versions and has 350 issues in it, if that helps.
Do you have any recommendations for what to check here? We have recently rebuilt the indices for this database.
Thanks,
Rich
richsonn
· 1 |
|
Tuesday, August 18, 2009, 2:12:07 AM |
0
|
We tried to replicate this without success. Is it possible to send a zipped backup of the database to support at countersoft dot com? |
||||
|
0
|
We see this, also. Actually, any page that collects a lot of information is often very slow--the project home pages, the filter page, the change log page, etc. The change log and road map pages are particularly painful, though, consistently taking a long time to load: times depend on project and how fast Gemini is working that day, but are typically anywhere from 1-3 minutes. Making things worse, it blocks the whole session, so you can't do other things in other tabs/windows while waiting for it the one page to load. My understanding is that Countersoft has looked at our install and was unable to do anything. I think they said we had too many versions or something. I could see that being an issue, but we're not convinced it's *our* issue. As of now, our install has 34 projects with 956 versions, 455 components, 3,149 issues, and 19 users. Keep in mind that those numbers were quite a bit smaller when Countersoft looked into it, but even as they are now, when talking about an industrial-grade DBMS like SQL Server, those numbers are very small and should pose no problem whatsoever, even given that most of the versions and issues are skewed toward a handful of projects. And I've seen other bug trackers running on lesser hardware with *far* more content that ran very fast. Indeed, I'm told that our Gemini install was much faster before a particular version upgrade (3.0, I believe). So I think a bug or bad optimization was introduced in Gemini that just hasn't been discovered yet. Hopefully, Countersoft will discover it soon, or maybe the bigger changes coming in 3.6 will evolve the problem into the dustbin of history. |
||||
|
0
|
Is it possible for you to send us your database? The issues filter page should not take more than 5 seconds to load. It might be indexing issue. |
||||
|
0
|
The global filter page (the one you get when you click the Find Issue button) is slower than the project-specific ones. I just timed the global one, and it took 24 seconds. It produced a list of 246 issues over 3 pages. I don't know if we can send you the database because it does contain some sensitive data. However, I'll bring up the topic in our meeting on Friday. We worked out something to let you help previously, so I'd guess we can do it again. |
||||
|
0
|
Our database is 48Mb compressed. Can I email you a link to it please? What is the email address I should use? |
||||
|
0
|
Hi Rich. Please email download link to support at countersoft dot com and mention this forum post. |
||||
|
0
|
Hello Bikram, |
||||
|
0
|
Yes, we have identified an issue and are working to fix it for 3.6.
|
||||
|
0
|
Thanks Saar, |
||||
|
0
|
FYI - We have now fixed the issue for roadmap and change log in 3.6. We expect to release a BETA within the next 2 weeks. |
||||
|