0008285: Sorting: sort by File Stamp, Date Added or Last Time Played is slower than other fields

ID	Project	Category	View Status	Date Submitted	Last Update

0008285	MMW v4	Main Panel	public	2011-08-24 22:09	2011-09-27 01:37

Reporter	petr	Assigned To
Priority	urgent	Severity	tweak	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	4.0
Target Version	4.0	Fixed in Version	4.0

Summary	0008285: Sorting: sort by File Stamp, Date Added or Last Time Played is slower than other fields
Description	Because of last changes in UTC date storage some fields are very slow when sorting (File Stamp, Date Added and Last Time Played).
Additional Information	http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=60109
Tags	No tags attached.

Fixed in build	1424

petr 2011-08-24 22:18 developer ~0027332	Fixed in 1423

jiri 2011-08-25 07:32 administrator ~0027338	The new concept of using 'fast...' is unnecessary, we can use '.._UTC' fields for sorting only. It will be at least as fast, but will not require additional memory.

petr 2011-08-25 10:27 developer ~0027340	Fixed in 1424

peke 2011-09-27 01:37 developer ~0027941	Verified 1436