Search found 1 match

by Rémy
Wed Jun 16, 2004 2:25 am
Forum: Databases
Topic: Enhance performance of mysql query
Replies: 6
Views: 895

First, normalize your table into an Artist-, Album-, Track- and GenreTable and then put the right indexes. Second, search only in the Artisttable, then search in the AlbumTable, then search the TrackTable and then combine the results (or show three resultsets to the user). Third, have you done a res...