MobileRead Forums - View Single Post - Handling a huge number of files on the SD Card

Mackx · 06-23-2011, 04:21 PM

Looking at libermetadb I see the following is used (when sorting on filename):

Code:

ORDER BY
    sort_priority DESC,
    (CASE WHEN filename IS NOT NULL THEN 0 ELSE 1 END),
    filename COLLATE IREX_CASE_INSENSITIVE,
    directory_path COLLATE IREX_CASE_INSENSITIVE

(sort_priority is used to get folder in front of files.) I am no database expert, so its just for information.

06-23-2011, 04:21 PM	#25
Mackx Guru Posts: 999 Karma: 19985 Join Date: Dec 2008 Location: Netherlands Device: iRex DR1000S	Looking at libermetadb I see the following is used (when sorting on filename): Code: ORDER BY sort_priority DESC, (CASE WHEN filename IS NOT NULL THEN 0 ELSE 1 END), filename COLLATE IREX_CASE_INSENSITIVE, directory_path COLLATE IREX_CASE_INSENSITIVE (sort_priority is used to get folder in front of files.) I am no database expert, so its just for information.