Moonbase;409966 Wrote: 
> 
> CS seems to unnecessarily do a resync after SC’s rescan has finished,
> and -twice- creates a new database (at least that’s what the log
> says).
> 
It shouldn't need a refresh at all in this case, but I think I missed
this case in 2.6 so it seems to still do a refresh. I'll try to fix it
in a future version.

The duplicate creation of the database is just a cryptical log message.
In a large table the fastest way to delete all rows that are part of a
specific scanning module is to:
- Drop the table
- Recreate the table
- Fill the table with all the entries besides those you wanted to
remove

A "delete" statement with a "where" directive is a lot slower when the
table is large. It uses delete statements if less than 20000 rows
should be deleted, with more than 20000 rows it uses the drop+create
sequence described above.

So what you are seeing in the log is:
- At 19:19: It deletes the Custom Tag entries and then performs the
Custom Tag scanning for about 30 minutes
- At 19:53: It deletes the Mixed Tag entries and then performs the
Mixed Tag scanning for about an hour (which seems extremely slow). I
wonder if this would be faster if it was performed in smaller chunks.

Moonbase;409966 Wrote: 
> 
> This behaviour is also seen when only doing a "scan for new/changed
> music".
> 
There is no support for "new/changed" rescan in Custom Scan at the
moment.
I think it might be possible to implement "new/changed" rescan in
Custom Scan but it would require me to use internal api's which could
change at any time, so I don't think I like to do this, especially
since the scanning process in SqueezeCenter will change a lot in 8.0
which hopefully will make the Custom Scan plugin obsolete.


-- 
erland

Erland Isaksson
'My homepage' (http://erland.isaksson.info) 'My download page'
(http://erland.isaksson.info/download)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan,  Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=61775

_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins

Reply via email to