Bug 3247 – CLI titles command takes excessive time with large library

Bug 3247 - CLI titles command takes excessive time with large library

Summary:

CLI titles command takes excessive time with large library

Status:	RESOLVED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	CLI
Version:	6.5b1
Platform:	PC Windows XP

Importance:	P2 normal (vote)
Target Milestone:	---
Assigned To:	Fred

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2006-04-06 01:27 UTC by Malcolm Green
Modified:	2008-09-15 14:39 UTC (History)
CC List:	0 users

See Also:
Category:	---

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 Malcolm Green 2006-04-06 01:27:39 UTC

With my library of over 11000 songs, the CLI titles (or songs or tracks) command takes several minutes to respond.  During this time SlimServer does not respond to the web interface, CLI or Squeezebox.  Either of the following command variations cause the problem: titles, titles 0 100.  But if you qualify the command with an artist, e.g. titles 0 100 artist_id:26, the response is quick.  The problem occurs with both 6.2.2 and 6.5.

Comment 1 Fred 2006-04-16 17:22:31 UTC

Need to change access method to DB for this command. The current way just does not work for large result sets.

Comment 2 Dan Sully 2006-04-22 15:18:07 UTC

I'm betting the split-scanner branch will help with this.

Comment 3 Fred 2006-06-30 17:46:18 UTC

From early testing with the new DB stuff, yes, this looks like fixed. Just have to do it!