Home Home
  login

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.




Performance issues page

usage
items
web-app

Hi, the issues list page takes a long time to load. I did some checking with the sql profiler and it seems one sql statement which is executed 2x takes the most time. It's the one where the gemini_issuesview is joined with many other tables and probably used in the issuesgrid. Can something be done to speed-up this query. It seems the amount of custom fields have a negative impact. thanks.
RemcoDekkers
· 1 		RemcoDekkers
Monday, April 16, 2012, 2:32:37 PM
Replies (5)
helpful
0
not helpful

Yes, open the web.config file and set the optimizecustomfields setting to yes.

··· What does this setting do? Should I also set optimizeComments to true?RemcoDekkersTuesday, April 17, 2012, 10:08:20 AM
Mark Wing
· 9108 		Mark Wing
Monday, April 16, 2012, 3:18:58 PM
helpful
0
not helpful

What does this setting do? Should I also set optimizeComments to true?
RemcoDekkers
· 1 		RemcoDekkers
Tuesday, April 17, 2012, 10:09:47 AM
helpful
0
not helpful
ANSWER

The setting will change the SQL is built and will fetch the custom fields after fetching the issues which will reduce the load on SQL server. Same works for comments if you have a lot of comments per issue.
Mark Wing
· 9108 		Mark Wing
Tuesday, April 17, 2012, 10:49:03 AM
helpful
0
not helpful

Great. Is there a reason to set these to "no"? I mean why is it an option?
RemcoDekkers
· 1 		RemcoDekkers
Tuesday, April 17, 2012, 10:55:46 AM
helpful
0
not helpful

Yes, most users will not have too many custom fields, comments etc... so fetching it all in one go is better.
Mark Wing
· 9108 		Mark Wing
Tuesday, April 17, 2012, 11:01:08 AM