Have you tried optimizing your query? It is more likely that the problem is a poorly optimized query and/or poorly tuned server than it is mySQL. Joins will be slow if you do not take the time to figure out the best way to do what you are trying to accomplish. Forcing the table order can really speed up joins as can making sure the tables are properly indexed and that the indices are being used by the queries. You also might want to think about tuning your server variables to achieve optimum performance.
The easiest place to start is running an explain on your query to see what you can change to make it quicker. -----Original Message----- From: Joseph Dietz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:40 AM To: [EMAIL PROTECTED] Subject: Severe performace problem linking tables with mysql PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type) I have discovered a performace issue when joining several tables together. The performance is extremely poor when performing select queries using the WHERE clause and joining the tables with the pk_media_id = fk_media_id etc... I guess this is what people might think about when considering using mysql. With SQL 2000 Windows Server, and ACCESS, there was no loss in performace. 4 of my tables are cross reference tables as such: pk=primary key, fk= foreign key Medias MediaAuthors Authors pk_media_id ---- fk_media_id, fk_author_id ---- pk_author_id (Many authors for each media) --------------------------------------------------------------------- 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
