While I chomp at the bit waiting to get my hands on the new SQLite code (Sorry MJGraf, I could not resist), I did some testing of the scan capabilities of MP2 for Audio.
Some of the things Morpheus_xx expressed in https://forum.team-mediaportal.com/threads/sqlitedatabase-plugin-for-mp2.118535/page-17 Got me thinking, again….
Starting with a clean install with SQLite: I configured the client to use the Titanium skin, changed the menu options to allow minimize of MP2 client, and did the initial scan of my music folder (f:\Music)
Note: I expanded this music folder to include multiple folders of Albums and some of these Albums have multiple CDXY in them. For this test I primarily used f:\music\verious\80’s Night
This album has 16 CD folders labeled CD01 thru CD16 in it. Total there are 299 items within all the CD’s.
While the initial scan was running , Resource Manager showed all the directories and files being accessed.
When the scan was completed (about 3 minutes), I went into MP2 Client and went into Audio.
The first level of albums was present but, when I opened 80’s Night it listed all 299 songs instead of the CD albums / folders.
Using Explorer, I went into f:\music\verious and deleted the entire 80’s Night album
Next I went back into Shares and initiated a ReImport
This time Resource Manager did not show any folder or file access.
When the scan was done, the client log showed the scan started but there were 2 errors listed
Thread23 and Thread87 had “Failed to update currently importing shares”
The server log had no errors, had a complete listing of all directories and files and did Not show any scan for f:\music\verious\80’s Night
Going back into MP2 (was in minimize mode), I pulled up Audio and 80’s Night was not listed.
As a result of this test a few things come to mind.
1) What are the Thread Issues registered to the client
2) Why does the scan stop at a level and not allow Subfolders to be used resulting in large media lists
3) How does the Reimport manage to complete the task without showing any file access within Resource Manager
Over all, the test results are both good (import works, reimport works to discover missing / deleted folders and files and all has great access times seeing the large amount of data being read from the folder and file structure) and bad (the 3 key issues).
On another note: Is there a count of folders and or files being kept in the DB or someplace else?
It might be nice if the Shares Import page process had some type of visual update telling the user / operator what the current status is.
This might keep someone from Killing process’s or powering off the server / client because they think the system is not functioning.
The server log zip also includes the SQLite DB files incase someone cares to look thru it. I would be interested to know if the album 80's nights has any residual still in the DB file.
As always, logs and other documents are included and if you have any questions, please let me know.
P.s. Is there a location I can create a personal test blog? I would like to keep a list of what I have tested and what tests I am going or designing to do.
Some of the things Morpheus_xx expressed in https://forum.team-mediaportal.com/threads/sqlitedatabase-plugin-for-mp2.118535/page-17 Got me thinking, again….
Starting with a clean install with SQLite: I configured the client to use the Titanium skin, changed the menu options to allow minimize of MP2 client, and did the initial scan of my music folder (f:\Music)
Note: I expanded this music folder to include multiple folders of Albums and some of these Albums have multiple CDXY in them. For this test I primarily used f:\music\verious\80’s Night
This album has 16 CD folders labeled CD01 thru CD16 in it. Total there are 299 items within all the CD’s.
While the initial scan was running , Resource Manager showed all the directories and files being accessed.
When the scan was completed (about 3 minutes), I went into MP2 Client and went into Audio.
The first level of albums was present but, when I opened 80’s Night it listed all 299 songs instead of the CD albums / folders.
Using Explorer, I went into f:\music\verious and deleted the entire 80’s Night album
Next I went back into Shares and initiated a ReImport
This time Resource Manager did not show any folder or file access.
When the scan was done, the client log showed the scan started but there were 2 errors listed
Thread23 and Thread87 had “Failed to update currently importing shares”
The server log had no errors, had a complete listing of all directories and files and did Not show any scan for f:\music\verious\80’s Night
Going back into MP2 (was in minimize mode), I pulled up Audio and 80’s Night was not listed.
As a result of this test a few things come to mind.
1) What are the Thread Issues registered to the client
2) Why does the scan stop at a level and not allow Subfolders to be used resulting in large media lists
3) How does the Reimport manage to complete the task without showing any file access within Resource Manager
Over all, the test results are both good (import works, reimport works to discover missing / deleted folders and files and all has great access times seeing the large amount of data being read from the folder and file structure) and bad (the 3 key issues).
On another note: Is there a count of folders and or files being kept in the DB or someplace else?
It might be nice if the Shares Import page process had some type of visual update telling the user / operator what the current status is.
This might keep someone from Killing process’s or powering off the server / client because they think the system is not functioning.
The server log zip also includes the SQLite DB files incase someone cares to look thru it. I would be interested to know if the album 80's nights has any residual still in the DB file.
As always, logs and other documents are included and if you have any questions, please let me know.
P.s. Is there a location I can create a personal test blog? I would like to keep a list of what I have tested and what tests I am going or designing to do.