search

SpartaSystems / holdmail

HoldMail is a Java Application for proxying SMTP mail, providing a browsable viewer for captured emails.
Apache License 2.0
32 stars 15 forks source link

Performance affected by size of database #77

Open wreddin opened 6 years ago

wreddin commented 6 years ago

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 commented 6 years ago

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

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

wreddin commented 6 years ago

We are using MySQL.

kblief commented 6 years ago

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