SQL Version Explained
Benefits Of SQL
The original version of the NICEIC software has been created in an Access database, which can easily run from a PC. This can handle a few users and their cert data but starts to struggle and slow down when there are multiple users accessing the software at the same time. With the SQL version, you can see the below improvements:
Firstly, an SQL server is optimised to work much more quickly than a client machine, particularly when dealing with several users and large amounts of data.
Secondly, the amount of data sent across the network link is vastly reduced. For most databases, the main performance bottleneck is data transmission over the network, so reducing this can give a dramatic improvement in performance.
Predicting performance improvements is very difficult but an average overall speed improvement of 3 to 5 times, and possibly much more, would not be unexpected.
With Access, each user reads and writes directly into the raw data of the software. If one of their machines crashes while writing something this will usually cause the back-end database to also crash and become corrupt. The same thing will occur if the network fails, has a glitch or temporarily becomes overloaded. This problem becomes more apparent as the amount of data or the number of users increases.
With an SQL server, users do not interact directly with the back-end data but with an intelligent data manager on the server. This then reads and writes data from and to the back-end software. If a users machine crashes, or the network hiccups, this will not affect the underlying database; instead the data manager realises that the transaction has not been completed and does not commit the partially transmitted data to the database. The database, therefore, continues to run without a problem.
Multiple Concurrent Users
A file server system, such as access, is designed for small groups and is best suited to run with up to about 10 concurrent users. Above this level, performance starts to degrade rapidly as more users are added. With the SQL server, hundreds of concurrent users can be supported without a noticeable negative impact on its performance.
What do we need to get set up with the SQL version of NICEIC Cert Software?
If you currently have the NICEIC Cert Software set up on a server with users accessing it, then chances are you will be able to get the SQL version put onto the same server. If you currently share the software from a user’s machine, then we would recommend setting up a server before implementing the SQL version.
However, there are some server requirements. This can be dependent on the number of users accessing the SQL.
- Intel® Core i5/i7/Xeon CPU or equivalent
- 16GB RAM or higher
- Windows Server 2012 R2, 2016, 2019 & 2022 – (for best performance we recommend the SQL database is not to be installed on a server with Microsoft Exchange).
- Microsoft .NET Framework 4.7.2 (or higher)
Clik will need to install a version of SQL onto your server. If you already have SQL installed, we can just install a new instance.
What happens after we process the request?
Once you request the SQL version of the software, we’ll get in touch with your IT department, and arrange access to the server you would like the NICEIC SQL database to be installed on. We will then begin getting everything set up in the background for you.
When SQL has been set up, we will need all your users to come out of the software to complete the conversion. The time this takes can vary depending on your database size but we estimate it to take between 15-45 minutes. After this, we can liaise with your IT department to ensure all your users are running the SQL database and not the old database.
If you need anything else explained about the benefits of SQL or have any requirement questions, please get in touch with our team on 0117 902 2012.