Whats the optimum way to set up these tables.

[poleposters]

Hi,

 

At the moment I have around five tables that are normalised.

 

I have one particular query which is used repeatedly on my site,hundreds of times more often than any other query, which involves joining the 5 tables and extracting data from one column in each table.

 

Would it be better to have the data required for this query duplicated in another table to save resources?

 

Or should I leave it as is?

[paul2463]

in my opinion just leave it, the reason you normalise tables is to save duplication of information and therefore disk space

 

queries run very fast and the fact that you pull information from all five tables in one query should not make you think of duplicating information, there comes a time when you want to remove all the duplicate information and finding it may be difficult

 

as I said in my humble, lack of proper, experience

[fenway]

Hi,

 

At the moment I have around five tables that are normalised.

 

I have one particular query which is used repeatedly on my site,hundreds of times more often than any other query, which involves joining the 5 tables and extracting data from one column in each table.

 

Would it be better to have the data required for this query duplicated in another table to save resources?

 

Or should I leave it as is?

That depends on the nature of the table, the column you're extracting, and how the query performs... post the EXPLAIN.