I have a database that I have created from DISCOG, currently it takes between 32 and 40 seconds to query the database for one record, my query looks similar to;
SELECT MIN(NULLIF(year, 0)) as year, genre, release_date, styles FROM track_master WHERE (artist LIKE '%Lo%Fidelity%Allstars%') AND (track LIKE '%Battle Flag%')
track are all indexed, when I ran the query with
EXPLAIN I received a
TYPE column, which as I've been reading is NOT good, however I do not know what else to do to optimize the query.
Besides the mentioned columns, there is also
id int(25) release_id int(25) album_title varchar(2250) master_id int(25) main_release int(5) artist_id int(25)