Thanks, hadn't thought of the COUNT(*). This still means visiting every
record of course, but at least on a good day most of them are being done
entirely within the database engine. On a bad day however this might not
gain anything if the user chooses to sort by something useless and
October 2015 11:48 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Find grid page containing record
There is I'm afraid something of a difference between "the UX we might want"
and "the UI we've got to which we're trying to add particular features".
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Find grid page containing record
Thanks, hadn't thought of the COUNT(*). This still means visiting every record
of course, but at least on a good day most of them are being done entirely
within the database engine. On a bad
he use
case at hand. The traditional paging may be appropriate but maybe some
new way as well.
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 07 October 2015 10:37 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Find grid page containing re
Den 06.10.2015 17:38, skrev Tim Ward t...@telensa.com [firebird-support]:
> Given that a query needed to return data for a page of a grid is of the form
>
> SELECT FIRST 25 SKIP
> .ID (and some other fields of human-readable data)
> FROM < plus tables as needed for other fields in the
> SELECT,