The answer depends on your requirements:
- do you need
views
sub selects
outer joins (which versions)
transctions
- whats are the requirements in terms of
reliability (redundancy)
scalability (performance, datavolume)
- whats is your budget
Some of our expiriences
mySQL
The last time we checked, transactions (or
to be more precise the interface to berkley
db) was alpha. I think this will take some
time to become a stable release. It is not
clear what this mean to the performance,
because I don't know any result with this
engine.
No views. I like to use views to hide some
complexities of the underlying db model.
No subselects. This is a very bad thing
for delete. You have do implement loops
where you normaly use sub selects.
Sybase ASA
Cheapest full featered commercial RDBMS
for web applications.
Blobs are just 32K in the current release
(Although the documentation says something
different)
Oracle
Quite expensive.
Never the less the db I made the best
experiences with.
Interbase
Some nasty bugs with outer joins
Cloudscape, InstantDB, Hypersonis SQL
All thre do not support views
> -----Ursprüngliche Nachricht-----
> Von: c cw288 [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 22. November 2000 21:00
> An: [EMAIL PROTECTED]
> Betreff: Need database recommendation
>
>
> Hi all,
> We are going to develop an application on apache + tomcat + mod_jk on
> Solaris 8, and we need a database for our application. There
> are lots of
> databases exit, we need some recommendation of which is easier to
> implement.
>
> Thanks,
>
> Cathy
> ______________________________________________________________
> _______________________
> Get more from the Web. FREE MSN Explorer download :
http://explorer.msn.com