hi We are evaluating few databases for developing an application with following specs,
1. OS not very important. Leaning towards Linux 2. Currently the database has about 5 million records but it will grow to 120 million records. 3. The tables will have billing information for a telecom company. Nothing complex. 4. Back office staff will use the data in the database to create invoices to be sent to customers. This data is not connected to the live telecom system [e.g. switches etc]. We get the data every day from the telecom company. 5. Staff may perform queries on the database to get reports like "busiest hour of the day" etc etc. I don't see too many concurrent users using the system, however the system needs to be stable. 6. Need to create excel, pdf files from the data in the database. This I think has nothing to do with the database, however this is a requirement. 7. Needless to say, good security is a must which will also be built into the front end application. We are considering the following databases, 1. MYSQL 2. Postgres 3. Oracle 4. MSQL If MYSQL or Postgres can do the job I prefer not to spend the money on Oracle/MSQL. However, if Oracle/MSQL are required for getting good reports and scalability, so be it. We will use Oracle/MSQL. Any pointers/advice is appreciated -- -- B.G. Mahesh mailto:[EMAIL PROTECTED] http://www.indiainfo.com/ India's first ISO certified portal --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
