Posted by Michael Fesser on 01/29/07 15:55

..oO(Arjen)

>I had to do the same thing for a project im working on. Worst case I had
>to join 10+ tables on the fly with more then 10k entries. Performance
>was terrible so I join the data overnight and dig in the large pool of
>data with a simple select :-)

10k entries are _nothing_ for a database, which is able to handle
millions of records. Even a join over 10+ tables shouldn't be much of a
problem, except maybe on a real high-traffic site. Are you sure the
tables were properly indexed? That's one of the most important things.
If every constraint or join requires a full table scan because of
missing or improperly defined indexes, then of course the performance
will be very poor.

Micha

[Back to original message]