Looks like your query scans more then 4K rows to produce 200 rows result
set.
15.01.2019 17:02, garima.j пишет:
Hi,
The number of rows in the table are 300k. In the SQL query, I specify the
limit as 10.
If I increase the limit to 200, it throws QueryCancelledException and times
out. Is timeout dependent on the resultset size as well?
Also, is there any way through which I can customize H2 timeout scanned row
count (instead of 4k rows).
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
--
Taras Ledkov
Mail-To: tled...@gridgain.com