[mythtv-users] MythGallery: selecting a favorite picture as directory thumb

[Angela]

> The many SQL queries might get called, because at any time data needs to
be
> known from the subdirectories.
> A datamodel, with a tree-like view in gallery_directories (parent_id) or
one
> table with directories and files having a parent_id and a type (dir/file)
could
> speed up loading.

Having a thumb_id attribute for directories pointing to gallery_files would
speed up things as only one level needs to be selected, which also would
solve my need to have a favorite picture for a directory.
For x4, you would need 4 attributes, or have an indicator in gallery_files:
select * from gallery_files where parent_id = xxx and indicator is not null,
or have a normalized gallery_directories_thumbs(dir_id, file_id) with up to
4 entries per directory.

Angela