You are not that far from the truth. 🙂

We have a few obvious painpoints caused by bad design in an 5+ year old application that has had a quite large increase in data and users.

So we do have a few candidates already for improvements - my experience just tells me to gain measurements to back it up before starting to improve something. Most often what you think is the biggest hurdle might not be - and the trouble may not be the big tables, but the excessive amount of queries.

E.g we have a rules engine to do validations in the user interface - which is overly trigger happy in regards to verifying with the database. Some screens do quite a lot of roundtrips on each keystroke - and with a rising user base this tends to become hurtfull... :w00t:

And Gila, thanks for your offer, in this round we will try to handle it ourselves though. As I said we have some candidates.

Best regards

/Anders