Database Choice


Performance and scalability: Database Choice

  1. Database Choice (4 messages)


    Not sure if this is correct forum, but I was hoping to get some feedback on possible database options for an e-commerce application we are finishing. We are running Caucho's Resin application server on Solaris 9; we purchased a license for Pointbase during development since it was very easy to get up and running, but have run into limitations with it (slow inserts, limited SQL support, etc.). The big boys like Oracle, Sybase, etc. are beyond our means both from a financial and personnel standpoint (no DBAs on staff), and some of these "post relational" object-relational hybrid databases seem well suited for Java development and web services deployment. Some research online has lead me to consider Intersystems' Caché and FirstSQL's FirstSQL/J. Caché appears to have the stronger client list and track record, while FirstSQL is very Java-centric. Has anyone had any experience with either of these (or have other recommendations)? I didn't find much in the archives except a few press releases.

    Threaded Messages (4)

  2. Database Choice[ Go to top ]

    It may be that you need to move from SlowLaris to Dell Linux or NewISys 2100, they are about $4K

    I use postgresql with resin, and it works fine on large sites of mine, and postgresql also powers, a very large site.

  3. Database Choice[ Go to top ]

    I like postgresql very much, but the last I heard SourceForge has moved to DB2

  4. What is a very large site?[ Go to top ]

    - Number of users
    - DB hits
    - ...
  5. Re: Database Choice[ Go to top ]

    I've always liked Borland's Interbase.
    It's open source sibbling, Firebird, is also good.