Sudheer Palaparambil wrote:

> I am developing an application for a publishing house. They have
> around 40 branches and 2 godowns across the state. Data is
> transferred to Head Office on a daily basis. Approximately 50,000
> records will be added to H O DB daily and there will be 25
> concurrent users approximately (Sorry, I forgot to mention about
> No of users in my last mail).
>
> Please advise on the configuration of a Server Machine, Firdbird
> DB Page size etc. We are planning to use Linux OS, also recommend a
> suitable Linux Distro.

Take as much RAM and fastest hard disks you can. SCSI is preferrable.
Also, a fast CPU would mean a lot. There isn't anything too smart about
it. You can even use two hard disks, and place the database files and
swap space on separate disks. Well, if it becomes a bottleneck - 50000
records are really not that much.

As for the distro, most I tried performed well. You should really use
the one you're most familiar with. I pick Slackware most of the time, as
it is really plain-simple and doesn't have any bundled software that
would hog the server resources. If you're a Linux beginner, I recommend
Mandriva. Other viable options are RHEL, SuSE, Debian and CentOS. They
all have their pros and cons, you should really test and find the one
that has the pros you need and cons that don't bother you.

> We will also look at the possibilities of a clustered system.

AFAIK, that's very though to do ATM.

--
Milan Babuskov
http://www.flamerobin.org