I am planning to build a website which is going to have thousands of members and want to make sure the structure of my database is as efficient as possible. The site within a few months should have hundreds of thousands of members and a table with possibly over 1 million rows to monitor some sort of click. I need to know how to structure this information so that it can be called upon as fast as possible and easily added to and updated when needed. I have worked alot with databases in the past but never on this scale. I am looking for someone with extensive database knowledge to answer questions and give me some sort of guide. I want someone who can show me a very very large site that they have done to proove their ability. I am willing to pay for this consultancy if I have to. Thanks David msn:
how do you want the tables to relate to each other? if you are only going to have one table thats going to be a huge list, then myisam is usually faster for searching/adding with a primary key. if you are going to have more than one table, you should have primary keys and indexes
This is why i want someone with extensive knowledge to give consultancy There will be multiple tables to handle different aspects of the site, Examples: Members Comments Friend Links Unique Views Unique Clicks Page Details Images And more, I thought about putting some of them togetehr then read that its more efficient to break tables up instead of having loads of columns.
Mysql has a detailed chapter on Optimisation. http://dev.mysql.com/doc/refman/5.0/en/optimization.html You may like to go through it.
Thanks, thats a big chapter would much rather pay someone who know to tell me but ill start reading just incase no-one offers Thanks again for your help though.
Well I have set up all the database now, so I am just looking for someone experienced to take a look at it and tell me what they think. I am sure I will be able to find someone at some point And at least you took the time you offer some help, thanks David