Bug 14717 – Add a urlmd5 field to the tracks table

Bug 14717 - Add a urlmd5 field to the tracks table

Summary:

Add a urlmd5 field to the tracks table

Status:	CLOSED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Database
Version:	7.4.1
Platform:	PC Windows (legacy)

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

URL:
Keywords:	TinySC

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2009-10-11 18:31 UTC by Gordon Harris
Modified:	2011-03-16 04:47 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 Gordon Harris 2009-10-11 18:31:28 UTC

An indexed urlmd5 column containing md5(url) hash values could be helpful for maintaining persistent track data.  See: http://forums.slimdevices.com/showthread.php?t=69242

This enhancement could potentially be a trivial one to implement as the md5(url) values could be calculated at scan time in schema_optimize.sql:

UPDATE tracks set urlmd5 = MD5(url);

Comment 1 Gordon Harris 2009-10-11 18:34:29 UTC

And to the tracks_persistent table too, of course.

Comment 2 James Richardson 2009-10-12 16:21:58 UTC

Andy: your thoughts on this enhancement?

Comment 3 SVN Bot 2009-10-23 12:43:59 UTC

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

Fixed bug 14717, add urlmd5 column to more efficiently join tracks and tracks_persistent

Comment 4 Chris Owens 2010-04-08 17:25:25 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!