Load ALL FOLDERS list from index instead of on the fly Query
Posted: Fri Feb 18, 2011 1:55 amIf this exists, please tell me how to do it with some code editing or a hack. If not, I'd love to see it as a variable option.
Explanation.
The All Folders (and other folders) drop down takes a couple seconds to query when you have a very large number of folders/subfolders. Even with using RAID0 and multiple volumes and Subsonic accessing these drives synchronously across mutliple controllers, the list takes a couple seconds to load.
My main concern with Subsonic is speed. I've done everything to make this thing scream that I could think of. The one thing that would make it even quicker would be to have Subsonic pull the folder list out of the actual index file, save it to a separate index file, and just load THAT each time the drop down box is changed -- instead of doing a whole new QueryOpen on the folders.
I don't care about up to the second accuracy for my folder list. It's indexed nightly, so up to the day accuracy would be plenty for me. This would improve speed GREATLY. Especially on first login, where sometimes a user has to sit through the white frame until it's fully loaded for the first time that session.
I understand that there are workarounds (such as having a separate folder listed as the first folder shown on login) -- but that doesn't solve the issues that a variable option to control this to come from a separate index file that only contained folders lists would solve.
Food for thought:
1. Because all root music folders specified must be processed with a QueryOpen command, this creates wear and tear on the drives (not a lot, but it's unnecessary).
2. Loading just the folder names from and index would SCREAM.
3. If this was an option, you could have your cake and eat it too. Or choose not to eat cake at all.
4. I wish I could program like Sindre. I would implement this today.
Thanks for reading, I appreciate it! Huge fan. Subsonic is the best.
Explanation.
The All Folders (and other folders) drop down takes a couple seconds to query when you have a very large number of folders/subfolders. Even with using RAID0 and multiple volumes and Subsonic accessing these drives synchronously across mutliple controllers, the list takes a couple seconds to load.
My main concern with Subsonic is speed. I've done everything to make this thing scream that I could think of. The one thing that would make it even quicker would be to have Subsonic pull the folder list out of the actual index file, save it to a separate index file, and just load THAT each time the drop down box is changed -- instead of doing a whole new QueryOpen on the folders.
I don't care about up to the second accuracy for my folder list. It's indexed nightly, so up to the day accuracy would be plenty for me. This would improve speed GREATLY. Especially on first login, where sometimes a user has to sit through the white frame until it's fully loaded for the first time that session.
I understand that there are workarounds (such as having a separate folder listed as the first folder shown on login) -- but that doesn't solve the issues that a variable option to control this to come from a separate index file that only contained folders lists would solve.
Food for thought:
1. Because all root music folders specified must be processed with a QueryOpen command, this creates wear and tear on the drives (not a lot, but it's unnecessary).
2. Loading just the folder names from and index would SCREAM.
3. If this was an option, you could have your cake and eat it too. Or choose not to eat cake at all.
4. I wish I could program like Sindre. I would implement this today.
Thanks for reading, I appreciate it! Huge fan. Subsonic is the best.