Re: help impressing the crowd (fwd)

Started by Oleg Bartunovabout 27 years ago1 messageshackers

oleg@sai.msu.su

about 27 years ago

This is a post from mod_perl mailing list. I think it would be interesting
to have a *real* benhcmarks, say more or less standard Web+db application
with using modern technique like mod_perl and persistent connection to db.
I'm using postgres since 1995 and quite satisfied with its features and
fast development, and support from mailing list. But in real life
every project needs good presentation and it's very difficult to
explain your boss or customer that Postgres is a good software without
real benchmarks and happy stories. Also, good web site is very important,
especially for attracting of new users. There was a thread in mailing list
about new feel'n look of www.postgresql.org and I saw some very promising
variants, what's going with this ?

Regards,

Oleg

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------- Forwarded message ----------
Date: Sat, 08 May 1999 14:03:39 +0000
From: Matt Sergeant <matt@sergeant.org>
To: Steve Maring <smaring@gte-es.com>
Cc: sbekman@iil.intel.com, modperl@apache.org
Subject: Re: help impressing the crowd

Steve Maring wrote:

I'm working on a customer support site for GTE Enterprise Solutions. We
provide real estate MLS services to REALTOR associations around the
country. The total customer base is about 120,000 and quickly growing.
The site will be a main source of information for customers. It uses
mod_perl, OpenSSL, HTML::Embperl, Apache::Session, and PHP3 for some
legacy stuff. It has an architecture that feeds everything dynamically
from a database using session management and per user routing and access
restrictions. I am in the process of studying design patterns right now
to see what the best fit is for this application. I will then be
optimizing for database connections, database performance (PostgreSQL),

^^^^^^^^^^^^

We've found PostgreSQL to be a severe bottleneck on our system. We're
not sure how much of a speedup we can get by migrating to a better DBMS,
but we're fairly sure it would be good. Unfortunately postgreSQL just
isn't fast enough for a high transaction web site IMHO. We just haven't
had time yet to transfer it to MySQL or SQL Server (hack, puke,
choke..). But we have done some profiling that indicated that postgreSQL
was the bottleneck. All this and we're parsing XML on the server too...
(for those that don't know - XML parsing is quite a bad bottleneck in
itself).

Can't really help Stas out with the link though - it's intranet stuff
only. Although it is a company wide timesheet system for 600 (so far)
users. Going very well. I may be giving a presentation at TPC, so I
don't really want any spoilers.

--
<Matt/>