[SOLVED] Which database(s) should I use for predominantly Write once/Read Many operations?

Which database(s) should I use for predominantly Write once/Read Many operations?

I'm building an application that needs to query a lot of data that is written once and not changed anymore. Should I use MySQL for that or should I use something like SimpleDB or BigTable? (I need to write once, read many times)

Thank you.

Edit: I want to use Heroku, big for me is more than 5MB. "Thousands of rows" take more than 5MB. That's why I'm wondering if I should use CouchDB, SimpleDB or MongoDB in order not to pay the $15 that Heroku charges. Suggestions to overcome this? Thank you all for the comments!

Solution

More important than your choice of database engine is your table structure. You should read up on OLAP database structure. Another consideration is the language you are writing in, make sure there is good support for the API of the database you want to use. CouchDB would be good as it has very low overheads due to the lack of relations/transactions.