james2hunt
Registered: Apr 2010
Posts: 100 |
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.
http://code.google.com/p/trade-manager/
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.
James
|
