Re: Which Database?

In article <34ecbb5d.37144150@news.mindspring.com> harringt@mind.ns.spring.com (P. A. Harrington) writes: >> 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. Yes, Howard, you could be looking at ... umm, $2 to $4 per user ... in building the system that you contemplate, inclusive of labor costs. You do the math.