Technical details
Our largest installation of the Firebird SQL has these attributes:
- Database size: ~70 GB
- Average daily database increase: ~80 MB
- Connection with economic systems (SAP, …)
- Connection with attendance systems
- Terminals connected in manufacture:
- Number of terminals with text-mode emulation: 32
- Number of graphical terminals: 8
- Number of terminals in quality control centre: 12
- Number of online connections with database: 43
- Average number of transactions per second: ~3.4
- Average number of transactions per day: ~290 thousand
- Server: MS Windows Server 2008 R2 64 bit
- Database engine: Firebird 2.5.2-64 in SuperClassic mode with UDF usage
- Operating time: 24 x 7
http://www.firebirdsql.org/en/case-studies-catalog/masa---statistical-analysis-and-plan-optimization-solution-for-industrial-plants-53264/