Optimized database maintenance
This is yet another update that might only be interested to the geekiest part of our customer base... but will definitely improve the lives of all of our customers, so it was well worth the effort.
(And yes, our engineering team has been on fire lately!)
Every software that deals with a database (of users, of synonyms, of articles, of categories, etc.) needs to make sure that its database and all of the tables inside the database are always in top-notch working shape.
Anything less than top-notch shape and you're risking data loss, data corruption and possibly even security issues. And we're always working crazy hard to stay not 1 step, but 20 steps ahead of all of these issues. 😃
This time around we rehauled the system we use for checking the condition of all our databases across our servers. Our previous system worked really well, however as the numbers of users/articles/synonyms in our databases kept on growing, it started to slow down the rest of our systems from time to time.
It was nothing too drastic, but in some cases our services became noticeably slower for about 20-25 seconds once or twice an hour. And our team was super happy to attack this not-even-an-issue-yet with all their technological might.
The new system is working like a charm, and the improved robustness and responsiveness of Spin Rewriter is something that I'm sure all our users will appreciate. 😃
(And yes, our engineering team has been on fire lately!)
Every software that deals with a database (of users, of synonyms, of articles, of categories, etc.) needs to make sure that its database and all of the tables inside the database are always in top-notch working shape.
Anything less than top-notch shape and you're risking data loss, data corruption and possibly even security issues. And we're always working crazy hard to stay not 1 step, but 20 steps ahead of all of these issues. 😃
This time around we rehauled the system we use for checking the condition of all our databases across our servers. Our previous system worked really well, however as the numbers of users/articles/synonyms in our databases kept on growing, it started to slow down the rest of our systems from time to time.
It was nothing too drastic, but in some cases our services became noticeably slower for about 20-25 seconds once or twice an hour. And our team was super happy to attack this not-even-an-issue-yet with all their technological might.
The new system is working like a charm, and the improved robustness and responsiveness of Spin Rewriter is something that I'm sure all our users will appreciate. 😃
For more posts, check out the Monthly Archives.
Our blog posts let our users stay up-to-date with all of the updates here at Spin Rewriter. This way you can discover all of the latest features — so you can try them out and tell us what you think.
We really appreciate all of your feedback — thank you!
