Database Improvment

[ManuelHeras]

Hello,

i have a big problem with subsonic database.

The file is getting really big some time greater than 5 gb

If i delete the file in /var/subsonic/db/subsonic.data the next start rebuilds the file with more than 5gb for a empty db.

For rebuild subsonic uses the file subsonic.script

If i delete the following lines from the script. the db has only 1mb after rebuild. After importing all media files the db has 135mb.

SET TABLE MEDIA_FILE INDEX'4843109 10107595 10107595 262900 4392440 68932 7437312 87502 4843109 1001531 4843109 4931565 4843109 117230'
SET TABLE ARTIST INDEX'4582715 69387 69387 4582715 1409'
SET TABLE ALBUM INDEX'6685748 171890 171890 6685748 6685748 6685748 52064 7206'

I think there is a bug in this lines. can this please bug fixed. Thanks.

Manuel

[frnx]

Did you try using Cleanup Database in the Settings page? AFAIK Subsonic keeps metadata about removed or moved files if you don't.