The last weeks and month I'd spent a fair amount of time on a redesign of the Swyx License Database. This weekend I have updated the productive system and am quite pleased with the results.
Two major "faults" had made the database very slow over the last years. As you all know the Swyx licenses are dongled with the hardware of the server machine. So, the first fault was to do all the hardware comparisons needed everytime one wanted to have a look e.g. on a customer. The second fault was introduced when implementing the SUS license management 2 1/2 jears ago. Because of a lack of time I had decided to make (intensive) use of "User Defined Functions" on the MS SQL server. In the beginning everything worked fine, but over the time, with more and more licenses in the database, the UDFs showed their major drawback more and more clearly: they became a performance problem.
So, if you ever have to design a database application, stay with the good old-fashioned Stored Procedures or Views and better do not touch User Defined Functions (unless you really know about the imapcts of them).
By writing this, the Swyx License Database is free of User Defined Functions and our License Fairy will definatley have more fun at work 