Sorting [was: Polygrid sorting]

[Paul Dupuis]

So what if you use the column headers on a PolyGrid (or whatever) to 
give the user a UI for sorting by column (adding, or not, sort arrows to 
the header labels).

Is it still more efficient to re-query the database with the new, user 
chosen, sort order and repopulate the PolyGrid?

Or more efficient to just resort the data already populated into the 
grid in the desired order the user has chosen? I suspect this later is 
the more efficient case unless you are sure you have a fast network and 
server with low latency and no competition for bandwidth.

As always, people's use-cases for these widgets vary widely. That is why 
the more versatile a widget is the often (but not always) the better it is.


On 8/25/2022 11:17 AM, Bob Sneidar via use-livecode wrote:
> Not sure how that happened. If the source is a DATABASE...
>
> On Aug 25, 2022, at 08:02 , Bob Sneidar via use-livecode <use-livecode at lists.runrev.com<mailto:use-livecode at lists.runrev.com>> wrote:
>
> +1 if the source is a dabs, sort during query.
>
> Bob S
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode