search

deecay / redmine_pivot_table

This Redmine plugin allows you to generate pivot table for issue analysis.
MIT License
52 stars 38 forks source link

502 Bad Gateway #24

Open pockmonst opened 8 years ago

pockmonst commented 8 years ago

I have a lot of issues(more than 1000) each has 60 fields. When issues less than 800, pivot table page are loaded but loading speed was slowed. And now, more than 900 issues, pivot table page occurred 502 Bad Gateway error. Can I resolve this problem?

deecay commented 8 years ago

Hi,

The speed limitation most likely comes from Rails' database access to issue table. So there is nothing much anyone can do except improving server performance. It might be useful to check your timeout settings though.

pivottable.js supports CSV, so exporting issue CSV on a regular basis and then using it as a pivot data can be an idea. But if you've got the CSV exported I think you should use Excel to analyze.

I might consider adding a URL parameter to specify CSV ad data in the future. Any ideas are welcome.