As you continue to measure, your database grows in size. By default, we install Microsoft SQL Server 2008 R2 Express.
SQL Server comes in different flavors to meet demands for different types of customers. The Express version has a database limit of 10GB (Gigabytes) while commercial licenses of the database server support a near unlimited storage capacity of 524PB (Petabytes). For typical quality assurance tasks and periodical scanning of ink zones in offset, the installed Express version will do fine for a large group of users and you do not need to upgrade to a commercial license of SQLServer 2008.
However, when you measure ink zones on big offset presses in full production and you wish to keep ALL data over time, that 10GB might not be enough. Of course you can delete older jobs and measurements but keeping that data available is of interest for statistical analysis. In these situations you might want to consider switching to a commercial license of MSSQLServer 2008 with it’s (near) unlimited data capacity.
Which database solution is right for you?:
| Usage |
SQLServer Express (included) |
SQL Server commercial license |
| Periodical QA measurements, less then 5 machines | + | |
| Periodical measurement of ink zones in offset | + | |
| Continuous QA measurements, 5 machines or more | + | + |
| Continuous measurement of ink zones in offset | + |
Calculated average size per measurement and typical limits for the free MSSQL Server Express:
| Use |
Average size |
Typical limit MSSQL Server Express (included) |
MS SQL Server Commerical License |
|
| Single row QA color bar (30 patches) | 45Kb | 185,000 | measurements | Unlimited |
| Three row QA color bar (72 patches) | 106Kb | 80,000 | measurements | Unlimited |
| 31 zone offset press (248 patches) | 372Kb | 25,000 | measurements | Unlimited |
| 54 zone offset press (540 patches) | 788Kb | 12,500 | measurements | Unlimited |