Ordering text

Rick Harrison harrison at all-auctions.com
Sun Mar 29 10:32:46 EDT 2020

Hi Terry,

Try having your database retrieval perform the sort and not LiveCode.

Use the SQLite: ORDER BY clause.

See if that gives you a faster result.


> On Mar 29, 2020, at 7:06 AM, Terence Heaford via use-livecode <use-livecode at lists.runrev.com> wrote:
> I have approx. 7000 lines of tab delimited data.
> When I execute the code snippet below if the sort order is descending it takes approx 120 milliseconds otherwise it takes 20 milliseconds to process.
> Can someone explain why and perhaps come up with a faster solution.
> Thanks
> Terry
> ——————————

More information about the use-livecode mailing list