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, W
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
unselectiv
: 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
for your users and the 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] Fin
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 f