[PLUG] Database layout vs. performance Addendum

[Alex Daniloff]

In most cases there are no more than three to five joints in general
SELECT query.


-------------------
> Another thing to consider is your table layout:
> 
> 1) How normalized will your data structure be?
> 2) Can you avoid 15-table joins for a general SELECT statement?
> 
> There are alot of things in addition to disk placement that can
utilize or 
> inhibit a database's response...
> 
> 
> 
> 
> -- 
> Brian Horan
> bhoran at hexdev.com
> 
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
>