LIMIT clause extremely slow

Hi,

I have an issue using a limit clause, f.ex.

SELECT * FROM table WHERE (index1 > 1 OR (index1 = 1 AND index2 > 5)) ORDER
BY index1, index2 LIMIT 1

index1 and index2 are index fields of datatype integer.

This takes some 100 times longer than in Mysql or other databases under same
conditions (and I have to repeat this command very often, so time is adding
up).

I have read in some forums that you can fasten it up by saying

ORDER BY index1 + 0, index2 + 0

The result is better, but still very slow.

Using version 16.1

Thanks for your help and best regards, Florian Melzer

___________________________________________

Melzer GmbH

Schlagturn 26, A-6135 Stans

FN 463940s beim LG Innsbruck mit Sitz in Stans

UID: ATU71726803

Tel +43 (0) 5242 71361

<http://www.melzer-kassen.com/> www.melzer-kassen.com

<mailto:office(at)melzer-kassen(dot)com> office(at)melzer-kassen(dot)com