On Tue, 11 Jan 2000, John Armstrong wrote:
> Hello all-
> I just got the word from down high that VC's will freak out
> if they see we are using mysql and now we are looking at an Oracle
> solution.
>
> The product is a mid level mod perl application that will
> receive ~500,000 hits a day. I want to engineer it to withstand up to
> 2 million hits per day ( not unique users ). Does anyone have good
> or bad stories about using Oracle with mod_perl/DBI/Apache::DBI? I
> would love to hear both sides of the coin. I personally think Oracle
> is overkill but I don't have any major issues with it.
Depends what the business is. If it is a serious business looking for VC I
would actually suspect the inverse is true: MySQL is underkill (I think I
just made that word up) due to its lack of transactions and other advanced
features (yes, these things do mean something in the real world).
Go with Oracle. It scales unbelievably, works forever, and comes with lots of
support. Of course you pay for it. A single web Oracle licence is going to
set you back around $25,000 (as will most commercial databases). If cost is
an issue check out Sybase ASE 11.3 which is free for even commercial use
(no support though) and has been solid for me for nearly a year now.
--
<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.