DJanGo wrote:
> i know that scan for changes isnt realy good.
>
> Just take a look to you db Files and wrote the filesizes of them.
> Change one single Track anywhere
> Do a rescan for changes
> Go back to the db folder and see how much bigger the db files are now.
Here's a before and after. I also restarted LMS in the hope of flushing
any SQLite transactions that may not have been committed. Very little
difference in size.
Code:
--------------------
C:\ProgramData\Squeeze\40\cache>dir *.db
Volume in drive C has no label.
Volume Serial Number is A4A2-7D6D
Directory of C:\ProgramData\Squeeze\40\cache
11/01/2013 12:55 AM 100,803,584 artwork.db
10/31/2013 05:36 PM 786,432 cache.db
10/13/2013 04:21 AM 69,632 imgproxy.db
10/31/2013 11:44 PM 53,456,896 library.db
10/31/2013 05:22 PM 13,897,728 persist.db
5 File(s) 169,014,272 bytes
0 Dir(s) 39,011,758,080 bytes free
C:\ProgramData\Squeeze\40\cache>dir *.db
Volume in drive C has no label.
Volume Serial Number is A4A2-7D6D
Directory of C:\ProgramData\Squeeze\40\cache
11/01/2013 12:55 AM 100,803,584 artwork.db
11/01/2013 01:16 AM 786,432 cache.db
10/13/2013 04:21 AM 69,632 imgproxy.db
11/01/2013 01:16 AM 53,457,920 library.db
11/01/2013 01:16 AM 13,897,728 persist.db
5 File(s) 169,015,296 bytes
0 Dir(s) 39,019,003,904 bytes free
--------------------
> But *dont* do a *vacuum* even with the LMS stopped - after that the db
> is completly bad - in case of lms show strange things somewhere.
I stop LMS and vacuum all of the the SQLite databases each night. I've
never seen any kind of corruption.
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=100277
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
