Home / Projects / Projects list / Database optimisation

Database optimisation

A Postgresql database storing data that is updated tens of times per second was getting slow to consult through the existing web interface.

After changing the structure of the data storage and creating stored procedures to handle data updates and reads, and developing a new and enhanced web interface exploiting the new performance optimisations, performance was back and the tool again usable, only with more features.