Hi all, im making a php app on a mysql db, whats the best/most efficent table format to use?

My system access the database alot, session, templates etc, i know mysql can crumble when load gets too high, however I hear a newer table format has row level locking?

Anyone care to enlighten me as to whts the best

Thanks to anyone who can help,
Taz