Hello! This would suggest that fetching a single row takes around 100 ms, in a slightly superlinear fashion.
Why is it a problem? What indexes do you have? Can you provide EXPLAIN plans? Regards, -- Ilya Kasnacheev пн, 20 янв. 2020 г. в 22:23, nunob <nuno.br...@finantech.pt>: > Also if I fix the LIMIT and vary the OFFSET I get responses of this > magnitude: > > LIMIT 1 OFFSET 0: 50ms > LIMIT 1 OFFSET 1: 200ms > LIMIT 1 OFFSET 5: 700ms > LIMIT 1 OFFSET 10: 1.3s > LIMIT 1 OFFSET 50: 7.8s > > Why is this? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >