I am using _xpack/sql/ to do the searching. By default the return records from ES it's 1000 per page.
If there are millions of records need to be returned. Fetch 1000 records per time in this case it's not effective. it slow down the performance. is there any configuration that increase the return hits records limit?