Simple Calendar is slow

[Andreas Kerpe]

Hi,

we have a JIRA 6.4.1 with Simple Calendar addon in Version 1.7.5.
When displaying the simple calender, is lasts 7-11 seconds until the calendar content is displayed.

It shows the same behaviour when clicking "Month", "Week" or "Day"-View.

We have checked the network connection, which is fast, the CPU load is not raising when loading.
With IE9 or Firefox same behaviour, so the client side seems not to be the problem.

Our database is an Oracle 11G. The rest of JIRA performs well.

How can we speed up the calendar?

Thank you in advance for any ideas.

Best regards,
Andreas

[Andrey Molchanov]

I suppose the performance issue to have been resolved with the latest update. Please contact us if it still works slowly.

[Andreas Kerpe]

When looking into the calendar, we see a huge number (aprox. 9000) times this SQL-Statement, with different issue numbers in the SQL log:
...

/rest/mailrucalws/1.0/mailcalsrv/events 0ms "SELECT ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE FROM PUBLIC.customfieldvalue WHERE ISSUE='31954'"

This seems to slow down the calendar a lot.
Maybe this is a hint?

[Nick]

Hello, Andreas. Now we are preparing a global plugin update. The performance will be greatly improved.

[Andreas Kerpe]

Hello Nikita, when are you planning this update? Thank you.

[Andreas Kerpe]

Hello Nikita, do you have an idea when an update will be released? Thank you.

[Andrey Markelov]

See, hmm

[Andreas Kerpe]

Each filter about 1-2 seconds.

[Andrey Markelov]

Does this filter works very good in Issue Navigator?

[Andreas Kerpe]

It is a saved filter, it is a filter for the same project for each calendar, but with a different field for each calendar.

[Andrey Markelov]

Ok. What is fliter for calendar? Just project?

[Andreas Kerpe]

We have 5 calendars. But the effect is quite the same if we enable 1 or all 5 calendars.

[Andrey Markelov]

Hi, please, how many calendars you have?