One vs more tables

krontrex · #1 (**permalink**) 12-16-10, 06:00

Dear all,
Is it true that querying one table is always faster than more of them. I need to decide whether to put all data in one table or to involve some associative tables. What is the criteria upon which the data model is chosen?
Thanks

r937 · #2 (**permalink**) 12-16-10, 08:47

Quote:

Originally Posted by krontrex

What is the criteria upon which the data model is chosen?

the inherent relationships in the data

pure and simple

blindman · #3 (**permalink**) 12-16-10, 08:50

Quote:

Originally Posted by krontrex

Is it true that querying one table is always faster than more of them.

Very few things are true always.

r937 · #4 (**permalink**) 12-16-10, 09:05

Quote:

Originally Posted by blindman

Very few things are true always.

including that statement

Internet Services

Web Development

Digital Marketing

Consumer Tech