Hello, raja_s_patil! Saturday, October 8, 2011, 9:37:06 AM, you wrote:
r> client wants to stick to FB at Branches for sure. But for centralized r> database they have doubt that whether it will sustain the volume of 10 r> to 15 GB and how it will perform and have given indication that they 10-15 GB databases now are the most average database size for Firebird. r> 1. Whether FB 2.1 SS / FB 2.5 ?? on 64 bit Linux (Kubuntu) will be r> able to handle 15GB database ? it will be able to handle even 1TB database with ~500 concurrent users. r> 2. What version should be selected FB 2.1, 2.5 and which architecture? Of course, the newer is better, so, 2.5.1. Architecture - Classic or SuperClassic, because only these architectures supports SMP. SuperServer does not support SMP, but can be used for ~20 or more users, if applications are not mix with OLTP and DSS queries. r> 3. What precautions should we take like Processor, RAM, Linux FS r> selection etc. etc. so that FB will run with maximum efficiency and r> stability. efficiency and stability depends on hardware. Pay attention to disks, use raid 10. At most systems hardware is very different, because of differen Firebird load, so, it's a bit hard to give exact suggestions. Since you already have Firebird with 1.5gb databases and ~10-15 users, I don't think that you need to look at hardware that, for example, 10 times faster than current. 15 users or 40 users - not a big difference, until you use 1-2 core processor and 1 hard disk (which is usually considered as a "desktop computer"). BTW, 1TB test, that Alexey mentioned, was intentionally made on desktop computer, not server. -- Dmitry Kuzmenko, www.ib-aid.com