Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Change Log takes 50 seconds to render

web-app

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
richsonn
Replies (10)
helpful
0
not helpful

We tried to replicate this without success. Is it possible to send a zipped backup of the database to support at countersoft dot com?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

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.


bobw
· 1
bobw
helpful
0
not helpful

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.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

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.


bobw
· 1
bobw
helpful
0
not helpful

Our database is 48Mb compressed. Can I email you a link to it please? What is the email address I should use?

Thanks,

Rich


richsonn
· 1
richsonn
helpful
0
not helpful

Hi Rich. Please email download link to support at countersoft dot com and mention this forum post.


Bikram
· 1
Bikram
helpful
0
not helpful

Hello Bikram,

Has your crack team identified any tuning opportunities or insights with the database you received last week?


richsonn
· 1
richsonn
helpful
0
not helpful

Yes, we have identified an issue and are working to fix it for 3.6.

 


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thanks Saar,

That is good news and we appreciate the update.

Kind regards,

Rich


richsonn
· 1
richsonn
helpful
0
not helpful

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.


Mark Wing
· 9108
Mark Wing