[eluser]InsiteFX[/eluser]
Like jedd has said above!
Have you check the memory issues?
How much memory does the server have?
What size will the tables and indexes be?
Is this MySQL Free or enterprize?
You do not state what kind of server or OS this is going run on.
These are factors to good database design.
Enjoy
InsiteFX