Bug 15385 – CLI titles query needs optimized

Bug 15385 - CLI titles query needs optimized

Summary:

CLI titles query needs optimized

Status:	CLOSED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	CLI
Version:	7.5.0
Platform:	PC Other

Importance:	P1 normal (vote)
Target Milestone:	7.5.0
Assigned To:	Andy Grundman

URL:
Keywords:	TinySC

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2009-12-30 10:49 UTC by Andy Grundman
Modified:	2010-04-08 17:24 UTC (History)
CC List:	2 users (show)

See Also:
Category:	Task

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Andy Grundman 2009-12-30 10:49:20 UTC

This query doesn't do correct joins and results in too many additional queries.  Adding join or prefetch to the albums table results in some strange generated SQL.  Should be ported to native DBI.  The large amount of tags available on this query makes this more difficult.

Comment 1 SVN Bot 2010-01-25 10:12:30 UTC

 == Auto-comment from SVN commit #29896 to the slim repo by andy ==
 == https://svn.slimdevices.com/slim?view=revision&revision=29896 ==

Fixed bug 15385, refactor titles query to use a single native DBI query for almost everything

Comment 2 Chris Owens 2010-04-08 17:24:58 UTC

This bug has been marked fixed in a released version of Squeezebox Server or the accompanying firmware or mysqueezebox.com release.

If you are still seeing this issue, please let us know!