Joseph Dietz wrote:
Medias MediaAuthors Authorspk_media_id ---- fk_media_id, fk_author_id ---- pk_author_id
In your table definition, is there an index on each of your keys shown above? What kind of performance 'degredation'? How many values are you checking? What WHERE or ORDER BY clauses are you using (try with none to test)? If possibly, pass along the original query that doesn't work as quickly as expected.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php