Question
What data usage factors have to be considered when deciding between using the free version of SQL Server (Express), or purchasing a more comprehensive version that has no limits on database size?
Answer
The database size scales in proportion to the modules purchased, usage of the modules, and the number of Linacs used.
Assumption: 2 Linacs, 70 myQA Patients
During this simulation of a typical usage scenario for a hypothetical user using the SQL Express Edition (limit of 10GB) with a full TG-142 suite of tests per Linac and projects with 123 slices, 2750 frames and 5 gamma calculations, the user would reach the 10 GB limit in ~1.5 years.
In case you have more than 2 Linacs and you will create more than 70 patient cases per year it is advisable to purchase the Standard version.