But cost-effective doesn't necessarily exclude Oracle. If the
biggest requirment is recoverablity after a crash then mySQL is still a bad
choice (no transactions makes the database state on disk at any point in
time uncertain as to its validity). Also, there could be reasons to choose
Oracle over PostgreSQL (like having to work with existing Oracle stored
procedures, or some of Oracle's other software).
My point is simply this (and its not just to you, but to everyone on
this list that immediately recommends solutions without knowing the problem
fully) - unless you completly understand the problem its very difficult to
solve it. This really comes up with trying to help users with their
problems. Someone asks a somewhat vague question and two or three people
are charging down a path towards a solution that might be going in the
opposite direction as to what the user wanted. This can be a big turn off
and push users away.
Randy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 10:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Tomcat,Apache,Linux,Oracle 8i,JDBC connectivity
I agree totally, mainly from the opint of view that no
advice should be given without the knowledge of the
requirement.
I was going out on a limb though, and guessing that
since linux and tomcat were chosen, a cost-effective
solutions was sought after.
Regards,
m
>Mike,
>
>I don't want to start an off-topic thread on this but #2
is poor advice if you don't know what types of
transactions are going to be
>needed in the app. There is a reason Oracle is used
by very large companies for very large databases.
>
>AFAIK neither of mSQL nor mySQL support
transactions nor a host of other "real" database
features. I understand they are great for
>dbs where, for the most part, all the users are doing is
queries and not updates.
>
>Also, while it makes sense that the missing features
should make them quite fast there is evidence to cast
doubt on that (at least
>for multi-user environments) here:
http://www.phpbuilder.com/columns/tim20001112.php3
>>
>> If you don't HAVE to, I would recommend:
>>
>> 1. Use FreeBSD, not linux.
>> 2. Use mSQL or mySQL, there's less processing
>> overhead.
>> 3. Tomcat 3.2.1 has performance improvements over
>> 3.1. (3.3 is cleaner still, but I'm guesing you won't
want
>> to use a milestone build)
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
