RE: MySQL vs. Postgres
On Wed, 30 Aug 2000, Scott Thompson wrote:
> Some stats for you. Keep in mind that these are only for the webserver.
> Hits Bytes Visits PViews Month
> 8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000
> 10,853,047 57,775,413,897 224,862 1,375,197 Jul 2000
> 9,121,259 53,851,857,460 210,680 1,421,053 Aug 2000
> Granted we have other clients, but I would guess that 60-80% of the
> consumers are 'real estate interested'.
> > We run mySQL here and created an application with PHP3/4 to interface with
> > the SQL engine. I will tell you now, that we re-wrote all the php pages
> > ANSI C as the performance was PATHETIC. (p2 350 with 256 megs of ram) The
> > performance was 10 times faster than php. Another thing that I notice
Was PHP installed as a server module or as a CGI app?
CGI PHP vs. CGI C of course the former is slower.
I'd like to compare modphp vs CGI C in your setup. Best way of course
would be to write your own dedicated server module in C. Best for
performance, of course...
____/ ____/ /
/ / / Marco Colombo
___/ ___ / / Technical Manager
/ / / ESI s.r.l.
_____/ _____/ _/ Colombo@ESI.it