Lookiing again at the output of the MySQL slow query log, notice that MySQL had to examine over FIFTEEN MILLION rows there. I have less than 25k tracks in my library.
I think there is a problem with one of the JOINs. Since I can't get the MySQL ODBC driver to link the v 6.5 tables to MSAccess (I don't think the driver likes BLOB data types) I haven't really been able to visualize what's going on in that query. But, I'm guessing that the JOINs are creating two result sets and MySQL is doing a count of the permutations and combinations of both sets. Or not. There is an awful lot I don't know about SQL databases. -- gharris999 ------------------------------------------------------------------------ gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115 View this thread: http://forums.slimdevices.com/showthread.php?t=26354 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
