erland;639605 Wrote: > Did this patch really made any difference ? > In my setup it's extremely slow with and without the patch applied.
With my database it really made the difference I have shown in my previous post. I have also run the query in Navicat Lite, on a Windows computer, using both database files (squeezebox.db, and squeezebox_persistent.db). The original query ran in 37s, the modified one in 100 ms. 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. -- Co1 Co van Winsum ------------------------------------------------------------------------ Co1's Profile: http://forums.slimdevices.com/member.php?userid=34002 View this thread: http://forums.slimdevices.com/showthread.php?t=88627 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
