How to avoid database lock up in Zen Cart

How to avoid database lock up in Zen Cart

I was having issues with the database locking up on the server. Each time Zen Cart makes a query of the database, it is locked and then unlocked when the query finishes. I have a lot of processes outside of Zen Cart also running on the server. Periodically, the server...