Reply to thread

Message: <blockquote data-quote="morpheus_xx" data-source="post: 1028599" data-attributes="member: 48495">I need to explain the queries above: they are filters for "Album" covers, where not a single MediaItem is queried, but the thumbnail of first MediaItem that has the requested album name. That's why I introduced LIMIT and OFFSET: album query returns 20 titles/thumbns, but I only need the first.I already planned to do this "paging" inside SQL layer, there is a comment and TODO. Problem is, that SQLCE has an error when using JOINS and LIMIT in a query. So maybe we create an extended DB interface for "paging" support, if the DB plugins doesn't support it, we fall back to current way (IDataReader.Skip().Take(), which is slower).The "paging" support is also a main feature for @[USER=18631]Valk[/USER] 's data source virtualization, so the DB can return only the needed range of a query.</blockquote>