View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0008094MMW v4Playlist / Searchpublic2011-07-07 12:232012-03-05 18:03
Reporterjiri Assigned To 
PriorityurgentSeverityminorReproducibilityN/A
Status assignedResolutionopen 
Product Version4.0 
Target Version4.1 
Summary0008094: Speed up some queries by using full-text search index
DescriptionAs reported here http://www.mediamonkey.com/forum/viewtopic.php?f=7&t=58668&start=15 , there are some cases where queries take a long time the first time after MM is started, obviously because of usage of 'like' SQL command, e.g. in case of searching for a string in Path. We should try to use the full-text search whenever possible.
TagsNo tags attached.
Fixed in build

Relationships

related to 0008377 closedLudek Expansion of some tree nodes triggers 1-minute freeze 
related to 0010975 closedLudek Advanced searching for 'Extension' and 'Parental Rating' can be faster 

Activities

jiri

2011-09-16 06:13

administrator   ~0027760

Note also, that particularly Path searching could be improved in case user searches for a full path (i.e. like C:\Music\Classical\), in which case we could use our internal folder structures for finding the path.

Ludek

2012-03-05 18:03

developer   ~0030615

Last edited: 2012-03-05 18:04

 Note that the SQLite's FTS3 engine can search on prefixes (not infixes) so it can be only used for conditions like:
Title | starts with | "ab"
but cannot be used for conditions like:
Title | contains | "ab"