This is my firat post here and in advance I thank all who kindly take the time to answer.
My question relates to the best way of designing a php/mysql high traffic site with respect to performance, use of resources, and bandwidth.
The question is as follows:
Assuming 100,000 users per day to a purely php/mysql site with each script either reading or writing to one table at a time, what are the pros and cons of designing the site as:
a) 40 tables/average of 15 fields each or
b) 10 tables average of 60 fields each
What is the effect of each option on disk storage, bandwidth, use of resources and performance?
For whatever option you believe is best, what do we need to do to optimize performance?
How do you calculate how much RAM is needed? We have 256 MB RAM now on a Pentium 700 MHZ dedicated server
Again thank you for taking the time to help us out
Frank
My question relates to the best way of designing a php/mysql high traffic site with respect to performance, use of resources, and bandwidth.
The question is as follows:
Assuming 100,000 users per day to a purely php/mysql site with each script either reading or writing to one table at a time, what are the pros and cons of designing the site as:
a) 40 tables/average of 15 fields each or
b) 10 tables average of 60 fields each
What is the effect of each option on disk storage, bandwidth, use of resources and performance?
For whatever option you believe is best, what do we need to do to optimize performance?
How do you calculate how much RAM is needed? We have 256 MB RAM now on a Pentium 700 MHZ dedicated server
Again thank you for taking the time to help us out
Frank