by Shakadula5153 » Thu Sep 18, 2025 7:00 pm
So I was sitting with about 235gig used on my 256 Gig Motorola Razr+. MM5 music used a boatload of that data.
Then I ran a script to concatenate the 4 digit year to the Title column. Worked great.
Then I start synching my playlists to my phone and.......Long story short, I ran up to 255 gig after synching about 30 playlists. My calculations only added about 108,000 bytes. So I added (7012) ......6 additional bytes per title. Nowhere near 10 or 15 gig. Can't figure this out.
So I thought about deleting MM on my phone along with the data and start from scratch but I wanted to check if anyone has encountered this issue before. My source library is a little less than 160 gig. It will take me about 6 hours to synch all playlists.
Here is the script I used to concatenate the date to the title.
UPDATE Songs
SET SongTitle = SongTitle || ' (' || substr(CAST(Year AS TEXT), 1, 4) || ')'
WHERE rowid IN (
SELECT rowid
FROM Songs
WHERE Year IS NOT NULL
AND length(CAST(Year AS TEXT)) >= 4
AND SongTitle NOT LIKE '% (' || substr(CAST(Year AS TEXT), 1, 4) || ')');
Thanks........
So I was sitting with about 235gig used on my 256 Gig Motorola Razr+. MM5 music used a boatload of that data.
Then I ran a script to concatenate the 4 digit year to the Title column. Worked great.
Then I start synching my playlists to my phone and.......Long story short, I ran up to 255 gig after synching about 30 playlists. My calculations only added about 108,000 bytes. So I added (7012) ......6 additional bytes per title. Nowhere near 10 or 15 gig. Can't figure this out.
So I thought about deleting MM on my phone along with the data and start from scratch but I wanted to check if anyone has encountered this issue before. My source library is a little less than 160 gig. It will take me about 6 hours to synch all playlists.
Here is the script I used to concatenate the date to the title.
UPDATE Songs
SET SongTitle = SongTitle || ' (' || substr(CAST(Year AS TEXT), 1, 4) || ')'
WHERE rowid IN (
SELECT rowid
FROM Songs
WHERE Year IS NOT NULL
AND length(CAST(Year AS TEXT)) >= 4
AND SongTitle NOT LIKE '% (' || substr(CAST(Year AS TEXT), 1, 4) || ')');
Thanks........