Registered: Apr 2010
08-16-12 05:04 AM
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 generated via the O/R mapping layer) or static.
How is you data sliced if at all. What type of transaction management have you implemented ? Where is your performance issue?
This link is to a project I've implemented in MySQL. You can download the DB and the DDL + Schema are included in the docs dir.
I would need to know a lot more info see above before I could give you specific advice. But PM/email me if you think I could help.