RE: MySQL vs. Postgres

2000-08-31 Thread Marco Colombo
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
> into
> > 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
> about

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...

.TM.
-- 
  /  /   /
 /  /   /   Marco Colombo
___/  ___  /   /  Technical Manager
   /  /   /  ESI s.r.l.
 _/ _/  _/ [EMAIL PROTECTED]




RE: MySQL vs. Postgres

2000-08-31 Thread Marco Colombo

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
> into
> > 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
> about

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...

.TM.
-- 
  /  /   /
 /  /   /   Marco Colombo
___/  ___  /   /  Technical Manager
   /  /   /  ESI s.r.l.
 _/ _/  _/ [EMAIL PROTECTED]


--  
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]