Re: [PHPLIB-DEV] php or asp From: Adam Thompson, MCNE, MCSE (athompso <email protected>)
Date: 04/18/00

BTW: this probably belongs on the main list, not here...

"Tony B. Gorschek" wrote:
> My question is if a proffessional web-site can be made in php
> with mySQL?

Best examples we have right now (that we can call our own):
        www.warehouseone.com
        www.benmoss.com
        www.larryk.mb.ca
        www.ttseeds.mb.ca

        **OUT OF PRODUCTION, BUT STILL UP/HIDDEN**
        www.winnipegliving.com
        ** This will redirect you automatically, but the old PHP-driven version
of the site can still be seen by going directly to index.php3. Please
don't give this out - all the data on the site is now VERY stale.

        **NOT OURS OFFICIALLY**
        www.workchannel.com
        ** Note: we are subcontractors - this is not our client but the code
was written by us.

> The concerns I have are:
> Speed, load-tolerance, power (asp vs. php), stability and so on...

So far, PHP3 and MySQL have yet to even cause a slowdown on any of our
servers. Some of the sites mentioned above are sharing a Sparc Ultra
10, and it doesn't even notice the load - at one point that server was
serving just under 1000 visits per day (not HITS, VISITS!) where each
visit would be about ~200 static hits (gif,jpg,etc.) and ~10 php3 pages.

The rest are sharing a dual P-II <email protected> running Linux. It only breaks a
sweat when someone runs session statistics reports - and MySQL still
handles it better than MS SQL. I know because I tried offloading the
work to an MS SQL server. It took over an hour for MS SQL to run the
report. Admittedly, it wasn't terribly well optimized, but MySQL does
the same report (on lesser hardware) in about 15 minutes.

Now, I know the Sparc hardware is more than adequate for handling
hundreds of visits per hour - we tried to stress-test it, but our T1
link (1.5mbps) was the bottleneck because the server isn't onsite here.

I measured (informally) that Ultra 10 box spitting out roughly 5Mbit/s
of PHP-generated pages, because I saturated both the T1 at work and the
cable-modem at home simultaneously. The load average while doing this
was no higher than 0.3 - so I don't have any worries about it.

Of course, now that I've mentioned them in public, all these sites are
going to take a pounding. *sigh* Be nice...

Keep in mind, that most of the fancy stuff is behind-the-scenes where
end-users can't see it, only the site administrators.

-Adam 

--
Adam Thompson, MCNE, MCSE, CWT, A+
Vice-President / Chief Technology Officer, Commerce Design Inc.
<athompso <email protected>>
tel: (204) 942-1648, fax: (204) 989-8080, cell: (204) 782-6198
-
PHPLIB Developers Mailing List. Send messages to <phplib-dev <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-dev-request <email protected>> in
the body, not the subject, of your message.