Hello Friends, We have been using Firebird since v. 1.5 on Linux as well on windows for Delphi application running on Win and server on Lin/Win as per needs in Lan environment. Now Client wants to have centralized database with two way Replication at HO. The branch database size varies from 200MB to 1.2GB and estimated combined database will be about 10GB to 15GB. On centralized database except replication connections (which will be Batch running as per Branch convenience and not real time) there will be 10 to 15 users always connected plus a small web application may have 30 to 40 simultaneous users as a primary estimate and may be on higher side. As far as Branches are concerned we are very happy with performance and Stability of database not a single instance of any data corruptions have been noticed in last 7 to 8 years inspite of very rough usage by Branch users so client wants to stick to FB at Branches for sure. But for centralized database they have doubt that whether it will sustain the volume of 10 to 15 GB and how it will perform and have given indication that they can Try first FB and if it fails they can go for some other Commercial Database. As far as we are concerned we would like to stick to FB but our confidence level is low since we dont have any experience of FB stability and performance on such large database. To make FB successful in this scenario please guide w.r.t. Following queries.
1. Whether FB 2.1 SS / FB 2.5 ?? on 64 bit Linux (Kubuntu) will be able to handle 15GB database ? 2. What version should be selected FB 2.1, 2.5 and which architecture? 3. What precautions should we take like Processor, RAM, Linux FS selection etc. etc. so that FB will run with maximum efficiency and stability. Thanks and warm regards. R. S. Patil.
