Normal
Believe me, there is a logic behind, i.e. to handle chained resources (i.e. ISO->VIDEO_TS) and especially folder-type mediaitems (DVD-, BD-folders). Maybe @Albert can check this logic for tuning possibilities (from logical level). I'm at work and can't do any analysis. Also there is not management tools for SQLCE that could show some query plans or other statistics.
Believe me, there is a logic behind, i.e. to handle chained resources (i.e. ISO->VIDEO_TS) and especially folder-type mediaitems (DVD-, BD-folders). Maybe @Albert can check this logic for tuning possibilities (from logical level).
I'm at work and can't do any analysis. Also there is not management tools for SQLCE that could show some query plans or other statistics.