We were called in to help our client who had database performance issues with their custom schema and queries. We made updates to the database tables and indices and reconfigured the RADIUS server appropriately. The output meant a 300 times increase in the performance of the original system with no customer application updates required.
Project description
A customer had designed a new system with a custom schema and queries. The custom schema and queries were required for use by their in-house user administration application. When the customer tested the RADIUS side for scalability, the performance was only at one percent of the level that they required for production. We were called in to help.
How we solved it
Our approach
We determined that the table indices were not as efficient as they could be. We added a new column, an index on that column, and a stored procedure to automatically update the entry on SQL insert, update, and delete operations. We then updated the RADIUS configuration to use the new column as a key part of its queries.
The results
The performance improvement was dramatic. The resulting system had over three hundred (300) times the performance of the original system. Even better, the changes to the schema did not affect the customer’s administration system.
The result was a customized RADIUS system that let the customer keep their existing administration application. This solution was significantly lower cost than replacing or rewriting the administration application.
Need more help?
InkBridge Networks has been at the forefront of network security for over two decades, tackling complex challenges across various protocols and infrastructures. Our team of seasoned experts has encountered and solved nearly every conceivable network security issue. If you're looking for insights from the architects behind some of the internet's most foundational authentication systems, you can request a quote for network security solutions here.
Related Articles
High availability and performance
Building a RADIUS system that can handle 10 million users takes time. Our experienced team can work with you to design a customized solution using your desired hardware and Operating System to achieve that goal.
My FreeRADIUS server is slow. What's wrong?
If you are encountering performance issues with FreeRADIUS, the first thought is usually to blame FreeRADIUS. In fact, it’s always the database which is the source of a system slowdown. Well, maybe not always, but 99 times out of a 100, it’s the database.