Re: FN-FORUM: PHP-Mysql-Linux vs ASP-MS SQL Server-Win2000

date posted 10th January 2004 22:02

Oh one thing I forgot to say is that in my office im the guy that writes
every ASP script fo rthos who need it. I dont get to use PHP as much as
I would like to .. However I have converted ASP(.NET) over to PHP but
with full support toa SQL Server ( via mssql Sybase connectivity ) the
SQL server holds over 1.24mill records with very big look ups the PHP
part provides a call centre and contact management interface that
enabled Stock dealers to handle new and existing contacts and take /
manage stock deals and terms of business so it does mail merges to Word
and creates PDF documents as well as build lovely sales and marketing
graphics.

When it was all in ASP.NET it was about 800k in code base size overall.
In PHP ists just a little under 302k..... and it does more in PHP than
ASP.NET was doing and its costing the customer £500 pound a year less in
PDF licesining. Meanwhile the Server that runs the main system has been
up over 402 Days with very little interuption. The previous ASP server
required regualr reboots for new patches and updates as well as
occasional memory leakges from the blasted thirsd party Mail and PDF
clients.


Oh and the new system now enables the customers web site to integrate
via a bridge with the database by bridging .. all db connections via a
transactional layer.

now SQL server is giving brillian response with PHP than it ever did
with ASP so its performance actually went up. As there are over 100
users connected making wel over 100 page requests a second.


So I ran out of time to explain this however... I will put up my hand
asnd say im the ASP developer of the group but I would say when starting
from scratch do it with Linux Apache Mysql and PHP (LAMP hey onlamp.com
) but replace MySql with PostgreSQL for the Big (100mill record
transaction a hour ) environments. For anything under 100 mill a hour
MySQL will handle alot for very little


and thanks to those who felt the post was unbiased. I took note of what I
had written ( after a few hours ) and will try to remember to post like
that in the future.

oh and Use Debian .

--
[EMAIL REMOVED] http://www.wired4life.org/ Wired4Life, an Answer.


-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GB d+ s:- a C+++ U++++ P++ L+++ E--- W++ N++ o K w---
O+ M+ V- PS+ PE- Y++ PGP 5+++ X R tv++ b+++ DI++ D---
G++ e* h--- r+++ z**
------END GEEK CODE BLOCK------