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

This page is part of a preserved archive of archives.hwg.org. The site is no longer active and its content is not maintained. For enquiries about this archive, write to archive(at)iwanet.org.