On mass updates/insert (like items of a host, or so), the updates should be encapsulated into a single transaction (wikipedia has good materials on DB transactions, if you don't know what are them). This will increase performance more the a lot. If you don't know why, i suggest reading any relevant books or papers on database engineering and/or designing. Having mass DML instructions encapsulated into a single transaction is an essential for such a big application.