I have 3 computers side by side taking orders. I have noticed that with all 3 being used simultaneously and 1 in another room plus possible home users the computers seem to work in sequence. So the third user I see click a button often has to wait for the first two computers to update. I'm already switching from shared hosting to a private dedicated server. I really can't believe that the table locking is taking as long as it is but the hosting company says too many queries are coming in at a time to lock entire tables. I find that hard to believe as we are only processing about 30 orders in a peak hour. These locks should be happening really fast shouldn't they?

Would there be a benefit to moving some tables from myisam to innodb? If so would triggers be necessary or possible to execute commits?