by JimGilliland » Fri Mar 17, 2017 10:09 pm
I'm seeing the same thing - rescanning the library is taking a ridiculous length of time to complete. I'm really regretting installing the beta.
When I first installed 6.1, the result was a completely unusable system. Cover art disappeared, and most of the library couldn't be played at all. It showed up, but when you clicked on a song, nothing happened.
So I deleted the database and let subsonic rebuild it. That solved the big problems. Cover art came back, and everything plays. The first scan to build the new database took about 18 hours, but I expected that.
Tonight I added some new music to the library, 15-20 new albums, so not a huge addition. But when I initiated the "Scan Media Folders", it ran very slowly. Normally, under Subsonic 6.0, it would take around 5 minutes to complete. But the current scan has been running for well over an hour, and it appears to be between 15 and 20 percent complete at this point. So a very crude estimate suggests that it is running more than 50 times slower than under 6.0. That estimate is not intended to be at all precise, but it does show that the difference in scan performance is huge.
At the moment the log file is about 4MB and growing quickly - it reached 6MB by the time I finished writing this sentence. The entire log consists of entries like this tiny extract:
/*C3250676*/SET SCHEMA PUBLIC
DELETE FROM ARTIST WHERE ID=449
INSERT INTO ARTIST VALUES(449,'The Who','D:\Rock\The Who\Join Together\cover.jpg',17,'2017-03-17 16:16:26.000000',TRUE,1)
COMMIT
DISCONNECT
/*C3250677*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250678*/SET SCHEMA PUBLIC
DELETE FROM MEDIA_FILE WHERE ID=29708
INSERT INTO MEDIA_FILE VALUES(29708,'D:\Rock\The Who\Who''s Next Deluxe Edition (Disc 1)','D:\Rock','ALBUM',NULL,NULL,'Who''s Next: Deluxe Edition (Disc 1)','The Who',NULL,NULL,NULL,2003,'Rock',NULL,FALSE,NULL,NULL,NULL,NULL,'D:\Rock\The Who\Who''s Next Deluxe Edition (Disc 1)\cover.jpg','D:\Rock\The Who',0,NULL,NULL,'2014-05-23 20:51:10.630000','2014-05-23 20:51:10.630000','2017-03-17 16:16:26.000000','2014-05-23 20:51:10.630000',TRUE,5)
COMMIT
DISCONNECT
/*C3250679*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250680*/SET SCHEMA PUBLIC
DELETE FROM MEDIA_FILE WHERE ID=2952
INSERT INTO MEDIA_FILE VALUES(2952,'D:\Rock\The Who','D:\Rock','DIRECTORY',NULL,NULL,NULL,'The Who',NULL,NULL,NULL,NULL,NULL,NULL,FALSE,NULL,NULL,NULL,NULL,NULL,'D:\Rock',0,NULL,NULL,'2014-05-23 20:51:10.646000','2014-05-23 20:51:10.646000','2017-03-17 16:16:26.000000','2014-05-23 20:51:10.646000',TRUE,5)
COMMIT
DISCONNECT
/*C3250681*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250682*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250683*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250684*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250685*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250686*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250687*/SET SCHEMA PUBLIC
DELETE FROM ALBUM WHERE ID=1990
INSERT INTO ALBUM VALUES(1990,'D:\Rock\The Yardbirds\Ultimate (Disc 1)','Ultimate (Disc 1)','The Yardbirds',1,139,'D:\Rock\The Yardbirds\Ultimate (Disc 1)\cover.jpg',0,NULL,NULL,'2010-10-24 01:00:13.243000','2017-03-17 16:16:26.000000',TRUE,2001,'Rock',1)
COMMIT
DISCONNECT
/*C3250688*/SET SCHEMA PUBLIC
DISCONNECT
/*C3250689*/SET SCHEMA PUBLIC
DELETE FROM ARTIST WHERE ID=450
INSERT INTO ARTIST VALUES(450,'The Yardbirds','D:\Rock\The Yardbirds\Greatest Hits Vol. 1 1964-1966\cover.jpg',1,'2017-03-17 16:16:26.000000',TRUE,1)
COMMIT
DISCONNECT
/*C3250690*/SET SCHEMA PUBLIC
DELETE FROM MEDIA_FILE WHERE ID=30015
INSERT INTO MEDIA_FILE VALUES(30015,'D:\Rock\The Yardbirds\Ultimate (Disc 1)\03 - A Certain Girl (The Yardbirds).mp3','D:\Rock','MUSIC','mp3','A Certain Girl','Ultimate (Disc 1)','The Yardbirds','The Yardbirds',NULL,3,2001,'Rock',320,FALSE,139,5649805,NULL,NULL,NULL,'D:\Rock\The Yardbirds\Ultimate (Disc 1)',0,NULL,NULL,'2010-10-24 01:00:12.933000','2010-10-24 01:00:12.933000','2017-03-17 16:16:26.000000','1969-12-31 19:00:00.000000',TRUE,5)
COMMIT
DISCONNECT