Dashboard MyLastChangedTickets slowing down znuny

[bfv]

Hi all,

After following the upgrade process to upgrade from 6.0.x through to 6.5.5, we noticed that the agent dashboard was taking a very long time to display. Users also started receiving timeouts on other actions.

We found out that some queries on the database were taking an incredibly long time (3-5 mins), degrading database performance to the point where Znuny became unusable until we killed those problematic queries.

The query in question:

Code: Select all

SELECT ticket_id, MAX(change_time) max_t FROM ticket_history WHERE change_by = 'xxxx' GROUP BY ticket_id ORDER BY max_t desc LIMIT 10;

It is performed by a new dashboard widget introduced in Znuny 6.4.4, https://github.com/znuny/Znuny/pull/177

My questions:

• Is there some kind of optimization I can run on the table in question (ticket_history) to speed up this query?

• Is there a way to permanently disable some widgets? For now I've set the default for the dashboard to 0 but I'd like to remove it completely

• Should I file a bug report for this?

[root]

Hi,

There is a fix already on the way. It's part of the next release: https://github.com/znuny/Znuny/commit/7 ... b92eee4f55

- Roy

[bfv]

Thanks a lot for the work and the swift reply!