by Ludek » Mon Apr 20, 2009 5:09 pm
@Guest
Have you already arrived back to the town? Could you also attach the debug log and also your DB if possible.
Studing the Lownlander's log I found out that this SQL:
SELECT DISTINCT upperw(substr( songtitle, 1, 1)) AS letter
takes the time and makes MM unresponsive, but Lownlander owns 800 MB's DB with 150k tracks, but on your 27k track's DB there should not be such a problem.
@Guest
Have you already arrived back to the town? Could you also attach the debug log and also your DB if possible.
Studing the Lownlander's log I found out that this SQL:
SELECT DISTINCT upperw(substr( songtitle, 1, 1)) AS letter
takes the time and makes MM unresponsive, but Lownlander owns 800 MB's DB with 150k tracks, but on your 27k track's DB there should not be such a problem.