Trying to decide on a storage engine
Hi all,
I'm in the design stages for a database that will power a Web-based testing/exam system, and I'm trying to decide between MyISAM and InnoDB.
At any given time, 20-60 students may be concurrently taking an exam, however I think I've got the design worked out such that it will never be necessary to make concurrent updates to the same row in any table.
In this scenario, which engine would you choose and why?
______________________________________________________________________________________________
#!/usr/bin/perl
for(74,117,115,116,32,97,110,111,116,104,101,114,32,80,101,114,108,32,104,97,99,107,101,114,44){print(chr($_))}