Re: MySQL Techniques
by "rudy" <r937(at)interlog.com>
|
| Date: |
Wed, 4 Dec 2002 16:09:50 -0500 |
| To: |
"Nathan Lyle" <nathan(at)upwebmaestro.com>,
"hwg-techniques" <hwg-techniques(at)hwg.org> |
| References: |
upwebmaestro |
| |
todo: View
Thread,
Original
|
|
> Any ideas?
any indexes defined on your tables?
you should expect to join these tables and get excellent performance
presumably when you display stuff on a web page you are not dumping
thousands of albums and thousands of artists and thousands of tracks --
perhaps just a few albums, and their associated artists and tracks, so it's
not the volume of data that's slowing things down, it's joining the tables,
and you need indexes for that
rudy
HWG hwg-techniques mailing list archives,
maintained by Webmasters @ IWA