Hi all,
I have an audio tracks info table, let's call it Tracks;
every Track can have one or more ' Character' ( it is not a genre, it
is something like 'Italian' or 'International' or '80's' or 'evergreen'
)
so a track can be 'International' and 'Evergreen', or 'Italian' and
'70's')
I have
list wont change that
often? should be ok.
--
Dave
- Original Message -
From: Giulio [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, July 12, 2004 1:50 PM
Subject: can you help me optimizing this query?
Hi all,
I have an audio tracks info table, let's call it Tracks
I've found a solution so I'm answering to myself, for who can be
interested and for asking if I've done something that could affect on
some way my DB performances.
I've added an index to both the columns that I use for the ON clause of
my left join query, and now it runs at the speed of
to:
|
| Subject: can you help me optimizing this query
:
|
| Fax to:
|
| Subject: Re: can you help me optimizing this query
