Performance affected by size of database

[wreddin]

We are finding that the performance of the application is affected by the size of the database. When the database grows too large the UI becomes slow to render. This causes our automated tests to fail.

As a workaround, we have created a job that deletes messages that are more than 7 days old.

The approximate size of the database for which we saw performance issues is150k messages and 1.1mill headers.

[kblief]

What database are you using? Is it the embedded h2?

There may be a need for some indexing on the database.

[wreddin]

We are using MySQL.

[kblief]

Can you, or someone in your organization, check the database for slow queries and missing indexes?