Gemini 5: showing Timeline makes our server unusable
We use Timeline as a great overview of recent changes. Thank you for that. For most of projects it works for us. Off course there is sorting issue: http://gemini.countersoft.com/project/GEM/2/item/5425 and alignment issue: http://gemini.countersoft.com/project/GEM/2/item/5427 and we hope that at least the firt one will be fixed soon.
We have a problem showing Timeline for one specific project. Gemini doesn't show it, browser waits for an answer from the server. When I look on the server (Windows 2003, IIS6) there is the aspnet_wp.exe proccess in the Task Manager which is eating full of cpu time. So we must kill it to prevent other apps on the server getting slow. This project is specific a bit. We use it for automatically generated crash reports sent by our software. So it is full of issues that are automatically generated via API.
- There is about 700 issues. Yes, our sw is buggy too ;-)
- We report crashes to Gemini for a long time, so it is about 100 issues in last 6 months.
- All of issues have long text and have two attachments.
What we have to check to improve the performance?
stepand76
· 504 |
|
Tuesday, December 11, 2012, 1:58:06 PM |
0
|
Is it just the timeline page for this project that is having a problem? |
||||
|
0
|
We encountered it only on the Timeline page. This is in the System log:
|
||||
|
0
|
I forgot mentioned that there is no component defined in this project. |
||||
|
0
|
Is it possible to send us a backup of the database (support@countersoft.com)? |
||||
|
0
|
The database (.mdf file) is about 1,3GB. Anyway I must discuss it within our team, becasue it contains private data. |
||||
|
0
|
Ok, we think we found what the issue might be. Do you have any comments against items in this project? |
||||
|
0
|
Following query returns 61 rows.
|
||||
|
0
|
Ok, is it possible to make a change to once cshtml file for a quick test? |
||||
|
0
|
Now it is OK, users are going to sleep. |
||||
|
0
|
Please open the views\activity\timeline.cshtml and change:
To:
That should speed it up and reduce the load on the server. |
||||
|
0
|
It is showing the timeline for 10 minutes and still not finished :-( |
||||
|
0
|
But we can browse Gemini during timeline is generating (it wasn't possible before). |
||||
|
0
|
No exception in the System log (yet). |
||||
|
0
|
Finished. It takes about 15 minutes. Result looks correct. |
||||
|
0
|
Ok, let us know if we could have the database so we can test it our side. |
||||
|
0
|
OK, thanks for now. |
||||
|
0
|
ANSWER
Fixed in 5.1.5. Thanks. |
||||
|