Firebird: otro caso de estudio

[[rretamar]]

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/