Co1;639655 Wrote:
> W
> I saw SQLite has an optimizer. To enable it to do its work, one has to
> run the command ANALYZE first. I did that in Navicat; it took 5 minutes
> to complete, but after that the original query still took ~35 seconds.
> The SQLite documentation says the order of joins is reshuffled by the
> optimizer (Query planner). Theoretically changing the order of joins
> should make no difference. But it also does not do any harm.
>
Thanks, can you try if it works better with Custom Scan 2.8.3363 which
I just released ?
It will execute an ANALYZE at the end of the rescan and it gave the
desired effect in my library. You will have to perform a rescan for the
changes to take effect.
--
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
