Discussion Locked

What OS for a server is best?

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am installing a server later this yeah (hopefully)...I have decided to use mandrake 7.2 and I'm unsure of what frontend would be best to run a database of either Interbase, MySql or MSaccess.

Any help greatly appreciated.

5 replies

by eugen prokopiev

I have much experience using both database servers, and when I can use MySQL, I am using it. While MySQL is in development state, it's stability became famous.

MySQL is faster and more reliable then MS Access - it's my opinion.

Eugen

by mtnsqs

Its not just reliabilibly but ability ot handle the task load you are going to put on the DB.

MSAcess is NOT a really good mulituser DB - its fine in single user mode, and for light multi user systems, but if you are serious even MS recommend upgrade to SQL server.

MySQL is quite good for a small environment, or a mostly read only DB - but it will get into trouble in large DB's - repsonse will degrade rapidly with 100 users all doing updates.

Interbase is again a small size DB/user limit. There is not mush support for it in some areas.

You need to sit down first and asses your needs and expected loadings, and allow for growth. You also need this information to determine disk space, and capabilities of the machine and network that the server is going to be on.

You also need to asses the skill sets needed to setup and use the DB's - do you have the necessary local support of vendors or consultants with REAL expertise, do you existing staff have the skill sets, or are they willing to learn or are there potential new employees in your area with the needed skills.

Of couse $$$ always comes into the equation. Remember that the initial cheaper solution, often ends up costing more in maintenance time and effort.
These type of questions have no simple answer.

This discussion is closed to new replies.