× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I would make the case for focusing for filtering over single-page-cuz-it's-not-staler:

* when one filters one can get relevant results quicker (usually 3 or
4 typed characters gets what a user wants)
* one can filter on partial words; it does not rely on
alphabetic/numeric order
* One can get non-contiguous rows that meet the filter (for instance,
all the companies in a specific ZIP code)
* refilling the subfile on every filter change will keep staleness at bay
* filtering allows grouping and sub grouping so drill-downs can be
designed with fewer steps
* filtering with SQL allows unique combinations of "order by" and
"where" without creating a long list of logical files.



On 4/6/2020 10:02 AM, Patrik Schindler wrote:
Hello Brian,

Am 06.04.2020 um 16:54 schrieb Brian Parkins<goodprophet.bp@xxxxxxxxx>:

Whilst this technique may entail more programming for Page Up/Down, it does mean the data presented is never "stale" by more than 1-page, (i.e. continually refreshed as paging occurs).
One of the more important points (for me) when considering Subfiles.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.