Customer Example - SQL

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 they tested the RADIUS side for scalability, the performance was one percent of the level that they required for production. We were called in to help.

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 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 their administration system.

The result was a customized RADIUS system that let them keep their existing administration application. This solution was significantly lower cost than replacing or re-writing their administation application.

Testimonials

"I just wanted to send along my thanks for the job that your team has been doing. They have been very responsive and worked on every issue I have sent him. Thanks for providing a great service to us."

M. Strider

"We at wanted to thank you for the services provided by your team. They did a tremendous job on implementing the Radius server in our network along with all the network components needed per our requirements. They had great flexibility with our changing requirements and ensure the work was completed on-time. If we need future development, we will definitely work with Network Radius."

D. Harshal

"You guys are awesome!"

Rob, Systems Engineer