MySQL Forums
Forum List  »  Connector/Node.js

Re: Using XML as a list in a MySQL Column
Posted by: Jonathon Coombes
Date: March 29, 2012 09:18PM

You are essentially looking at a 1:N relationship here with the artist_id join. The fact that you use ExtractValue() in the join condition will mean that index usage will be impossible and the join will be slower because of it. In a properly normalised form the Songs table will have multiple entries if there are multiple artist_id values for that particular song. That is, if there are 3 artists for a particular song, then 3 records will need to be created with duplicate values for a normalised relation.

Options: ReplyQuote

Written By
Re: Using XML as a list in a MySQL Column
March 29, 2012 09:18PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.