tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ralph Einfeldt <ralph.einfe...@uptime-isc.de>
Subject AW: Need database recommendation
Date Fri, 24 Nov 2000 14:58:10 GMT
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:cw288@hotmail.com]
> Gesendet: Mittwoch, 22. November 2000 21:00
> An: tomcat-user@jakarta.apache.org
> 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


Mime
View raw message