Re: Which Database?

Howard Yen <hty1@cornell.edu> wrote: > I need to use a database for a web site that implements stock trading. >We need to >be able to support 500,000+ users where each user will have his/her >account along with his/her portfolio, transaction history, etc. the >database needs to be access over the web. > >there will also be transaction involve where at the end of the day users >order (buy, sell etc.) will need to e executed. > >I need a database that is robust, scalable and that can support a lot of >records and tables. > >I heard about MySQL is it any good? how well does it compare to Oracle >or Sybase. > Howard, There are only two relational engines that I know of that will support an MPP platform natively (and considering your loads, you REALLY need MPP). The two are Teradata and Informix. Teradata is not an OLTP engine (and you are building an OLTP application), so that leaves you with Informix. Oracle has a layer that allows it to approximate MPP support, but it does so at the expense of performance. Oracle is about at its limit and really needs to rewrite its kernel. Sybase will run on any Unix platform that supports MPP, but I don't think it supports MPP natively (I could be wrong, its been a long time since I had my hands on it). If your load calculation is accurate, there really is no "cheap" solution to meet your requirements. ..P Please remove the ".ns." in my email address. My hope is that it cuts down on the spam in my reader.