Search found 1 match
- 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...