Ordering text

[Rick Harrison]

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.

Rick

> 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
> ——————————