OK MySQL and web based. Pray tells us more about the system/software architecture.
Are you Java/C/PHP/Pyphon/Ruby & Rails e.t.c ???
What are you using for O/R mapping? How many end users, How many concurrent DB connections, what are you using for DB pooling. Is your SQL dynamic (i.e...