I'm creating a service like FriendFeed. For the database, what's the best to have the tables with InnoDB or MyISAM?
- There are a lot of selects and Inserts.
- The table must be serchable, sortable when a user is inserting something.
- At the end, it must have quite a lot of rows. (Depending on the table).
- First, the database will be in one server.
- I would like backup without locking the tables.