AW: Any way to speed up "ORDER BY"

[Rudolf Bargholz]

Hi Das,

in order to help here you would have to show us the complete SQL with which you are having problems. This would give us an indication what indexes might help here to speed up the ordering of the data. It would also help to know what indexes you already have on the table, to see if these actually help with the ordering. This could however also be a limitation of SQLite. Another thing to note about indexes is, the SQL optimizer of the database normally uses only ONE index per table when optimizing and executing the SQL, so it can help to have different indexes, some compound indexes, for different use cases to speed up SQL execution.

Regards

Rudolf Bargholz

-----Ursprüngliche Nachricht-----
Von: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> Im Auftrag von Das Goravani
Gesendet: Dienstag, 26. Mai 2020 23:12
An: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Betreff: Any way to speed up "ORDER BY"


I have one case in my app where I have to use “ORDER BY” in order to get the SQLite to read the index the way I want.. 

And in implementing ORDER BY I have had SUCH a huge performance hit.. I think..

It seems that ORDER BY is really slow

Is there a way to speed it up.. or is your only option to optimize your indexes so that you DONT need it.. is it always a speed hit? 

Any idea when 10.2 is going to come out? 
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com