Quote: sales@farpost.com
24/7 Support: support@farpost.com

Windows, Linux or FreeBSD??

Question

We are planning to build our online catalogue on a dedicated server. A big quantity of images will be hosted and shared with many websites of our distributors. Efficiency and stability are the major issue. Budget isn't a problem. But we can't make our decisions which plan to pick up.

1. Windows 2003 Server + SQL server + .Net Framework
But is there a connection limit of IIS?
What about the stability and safty with Windows 2003 server??
They say Windows servers got down very often...

2. Linux + Apach + MySQL/PostgreSQL + PHP
MySQL isn't as powerful as MS SQL
And postgreSQL have a maximum concurrent connection limit of 30 ( right?)
Also we are worrying whether speed of PHP+mysql applications will catch up with asp.net+SQL server

3. FreeBSD + Apache + MySQL + PHP/JSP
People say FreeBSD is better than Linux. We are not very sure about it.

As we are not experienced with such cases, any suggestions will be greatly appreciated!

Thank you guys!!

Robert

Answer

We are planning to build our online catalogue on a dedicated server. A big quantity of images will be hosted and shared with many websites of our distributors. Efficiency and stability are the major issue. Budget isn't a problem. But we can't make our decisions which plan to pick up.

1. Windows 2003 Server + SQL server + .Net Framework
But is there a connection limit of IIS?
What about the stability and safty with Windows 2003 server??
They say Windows servers got down very often...

2. Linux + Apach + MySQL/PostgreSQL + PHP
MySQL isn't as powerful as MS SQL
And postgreSQL have a maximum concurrent connection limit of 30 ( right?)
Also we are worrying whether speed of PHP+mysql applications will catch up with asp.net+SQL server

3. FreeBSD + Apache + MySQL + PHP/JSP
People say FreeBSD is better than Linux. We are not very sure about it.

As we are not experienced with such cases, any suggestions will be greatly appreciated!

Thank you guys!!

Robert

Answer

Robert,

The truth is that there is no difference. No, really..

1. (win) No, iis has no connections limit. Actually its matter of win license you got, or lets say if you get win2k pro (workstation edition) your IIS is limited to 10 connection, so just get Win* server.

Windows instability time has gone. If somebody says "Windows servers got down _VERY_ often", then just find anybody else who can really setup winbox.

I believe 70% of the Internet server are running by linux/bsd or other *nix servers. So there are much more *nix professionals and if you come to hosting forum which is 100% full of linux/bsd addicted ppl (btw im linux fun myself :) - so everybody vote for linux/bsd. But if you come to any windows forum it will be vice versa. From my own experience (we support over 300 linux/bsd & 50 win server) there is a small or no difference in stability/safety terms.

2. (linux) yes, mysql isn't as powerful as MSSQL and I guess it will never be.. (at least in next 3-5 years). But as I can imagine images catalogue system (even hugest one :) - it requires nothing MySQL doesn't have. BTW you could setup linux+apache+php as web-frontend and win mssql as DB server.

PostgreSQL has configurable connections limit (max_connections variable at postgresql.conf file)

Yes, MSSQL apps. could outperform MySQL, however its vice versa at small amounts of data (especially if you don't use transactions at mysql :-). And don't forget PHP is interpreter (there is zend, I know, but its still interpreter) - so it will be always slower C/C++ compiled applications.

3. (bsd). Linux vs BSD is the same holy war as Win vs *nix. IMHO there's no big difference, but you better search google for professional reviews:

http://www.pulia.nu/~diox/tutorials...d_vs_linux.html
http://www.linuxmafia.com/faq/Linux...comparison.html

(if you find something fresh - please let us know)

And dont got with JSP if you care about performance.

---

As a conclusion. Dont go with PostgreSQL (mysql is absolutely winner), nor JSP (its slow). Just choose mysql+php (at linux or bsd) or mssql+.net at windows. Or better find developers team you trust, provide them details of the task and ask them for platform choice. Its difficult to give reasonable answer without knowning details .

I would go with mysql+php @ linux , PHP is really fast for small & medium applications development - so you could faster be on the market.