On Tue, 05 Oct 1999, Frank Livaudais wrote:
> > Check out slashdot: <URL: http://slashdot.org> which serves up about half a
> > million hits a day (all dynamic) from a single dual xeon box running
> > mod_perl.
>
> What database is this running? Does anyone know? We are looking to run Oracle 8i
> on a Sun box with Solaris. Our biggest hit has been on the database side. I
> think our mod perl side can take it, but are there special ways we could configure
> it to interact better with a database server, etc?
It's running MySQL, and Oracle is your problem. The trouble is it's just
too damn slow (no flame wars please, unless you've run side by side
comparisons to prove me wrong with 8i - my tests were on Oracle 7). Either
switch to Sybase (significantly faster while still offering all the
features of Oracle) or realise that you don't need all those features and
switch to MySQL. (MySQL doesn't have views, triggers, transactions and a
bunch of other important features that Oracle provides).
--
<Matt/>
Details: FastNet Software Ltd - XML, Perl, Databases.
Tagline: High Performance Web Solutions
Web Sites: http://come.to/fastnet http://sergeant.org
Available for Consultancy, Contracts and Training.