Re: Choosing a right database
>I need an advice from gurus of database design and development Enthusiastic amatuer >I am building a database that will have around 1 million users. At any >given moment about 5,000 of them are connected to the database. >The chosen database should be able to perform around 500 reads/writes >per second. How are they connecting? Are these 1M individual users or are they connecting thorugh a common username? How many login per minute are you expecting, are you expecting peaks and if so how high? >Is there a database that can support such a task and if yes, which one >is the best in your opinion? No doubt in my mind - Informix, but you are going to need some serious hardware. Sun E1000, IBM SPs etc. (they are others SGI, NCR, HP etc but I've never used them) Personally I prefer the 10K, having managed to get 1500 concurrent users on a SE engine. >My first thought was Oracle, but after doing some research on Web, it >seems like that a lot of people prefer Informix over Oracle. Orifice has the best marketing so the beancounters like them, having only ever worked on one Orifice site I can really say was it confirmed my faith in Informix >Which would you choose (or may be there are some other databases that I >am not aware of that would suit better for this project) - no Sybase or >MS Sql-Server, >sorry to people who like them??? The only other DB that might be in the running is DB2 Paul Watson WF Software Ltd Tel: +44 1436 674729 Fax: +44 1436 678729 www.wfsoftware.com/informix # If you broke it, hide the evidence ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************