MySQL Queries (OT?)

I'm working on putting together a music database for a local radio station,
using PHP and MySQL and am having problems getting the sort of query I want
to work fast enough... but I'm not sure if this is "list-appropriate" as
far as a topic. My problem is basically that even using Indexes, I can't
get info from 3 tables to relate fast enough to be practical. I think my
best time so far is 34 seconds, which to anyone using a browser, is an
eternity. :-{

Anyway, if anyone out there is a whiz at writing queries or can tell me if
the topic is an appropriate one I can elaborate further either on or off
list. <fingers crossed>

~ Nathan Lyle

Email: natelyle(at)chartermi.net
Phone: (906)485-4806
http://www.nathanlyle.com

"Those that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." - Ben Franklin

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA