Data structure for more files
I am looking for an efficient way to sort albums with songs. I have about 10,000 and growing albums with about 10 songs on each album. So this means 100,000 files.
Now I don't want to keep all folders (albums) in one main folder, but I am looking for a better way to save it. All folders are equal in hierarchy, so I decided to group the folder by initials or just simply pack 1000 folders into another folder. But many people say it can be messy.
What do you suggest?
(I know this is not directly related to programming, but I believe data storage is also important)
source to share
Write a content management program where you can upload your mp3 files, move the file to a folder in its structure, and write a record to the database.
Store information in the database, including the physical path.
Query the database when you search and ask your control program to open the path in Windows Explorer (or just bind it to your music player).
source to share
Assuming you are trying to access them from the filesystem and not through some other software, your best bet is to create a hierarchy that can be easily moved around. I would use initials as you suggested.
Group them by the first letter, then by the second letter, as deep as you need to get small groups. You don't need to go the same number of levels for each group. "T" can go 5 levels, but "Q" only one.
source to share