Co1;639294 Wrote:
>
> Clearly my preference at this moment is for MySQL. If I can help
> optimizing the SQLite performance, I will gladly try to help, because
> apparently Logitech will not actively support MySQL any more in the
> future.
>
If you enable Logging of "plugin.custombrowse" on debug level, you will
see all the SQL statements executed. That's a good start if you like to
start optimize queries.
I'll probably drop MySQL support completely in Custom Browse when used
with 7.6, it's too much work to maintain bot SQLite and MySQL in the
queries since Custom Browse uses some stuff which is database engine
specific.
Also a bit of warning regarding Custom Scan and 7.6, the refresh
operation in Custom Scan doesn't work with SQLite, to be specific it
contains a query which is really really really slow, it was stuck for
an hour in my 3400 track library this morning before I killed SBS. I
plan to take a look at it but I haven't had the time/inspiration yet.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=88627
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
