As part of our future roadmap, we’re committed to making big improvements to License Statistics. To move us toward this goal, we’ve hired a number of new engineers who are working hard to help us realize our ideas.
One obstacle to improving the software has been License Statistics’ SQLite database, which stores more than 10 million records for some customers. Unfortunately, SQLite is not designed to scale to this level, so we’ve come up against a number of problems in terms of scalability that have hampered our progress.
For a long time, we’ve had to make quick fixes to work around SQLite speed constraints, such as needing to generate a number of the web pages in the background at night, since it was simply not possible to generate them in real-time.
But now, this is over!
After spending several months changing nearly the entire internal engine, we’ve incorporated MySQL as part of our distribution. This enables MySQL to work as an embedded database, so there’s no need to set up an external database server (though we still optionally support this).
With the new database, we expect to be able to increase the scale to hundreds of millions. The initial goal is to be able to store more than 500 million records, which is over 10 times more than we do today. Furthermore, it is possible with this database to store large amounts of data. This has already enabled us to change the way the software works so License Statistics can generate all reports on the fly, instead of generating them at night.
This will make it possible for the largest enterprises to use License Statistics and benefit from the unique features that it offers.
This is only the beginning. With the new database opening up many more possibilities for improvements, we plan to use this structure to enhance License Statistics with even more features and additional types of reports that were not previously possible.
Over the coming months, we’ll continue to give you updates on new developments as we proceed. And as always, we welcome you to contact us about your own unique needs, so we can help you better.
