N/query allows you to return 5000 or do a runpaged with a max of 1000. Is there a way to marry the 2 and do a runpaged where it pulls back 5k at a time? I have 300k results and I am trying to return back those 300k, with n/query, as quickly as possible

Don't believe so, 1000 per page is the way to go

do the opposite, use the ResultSet to get 5000 results at a time

Is it possible when loading an existing workbook?

you can get it pretty fast if you treat the internal id as a number

Ok, so I would need to load it and then add an additional criteria

yes

Would the additional effort be worth it in speed?

probably depends on the ratio of time spent on the query vs time spent transferring the column data

Do you have an example you'd be willing to send?

as in how to add a condition to a query?

Sure! I can look it up and play with it but I figured if you knew where an example was I would ask

Ah, yeah this one has a different sort than internal id which I just thought of. Not sure if that would work. Is there a way to say, run the search, grab me 0-4999 and then grab 5000-9999?

@tdietrich recommends nested queries to use rownum

Just looking at the lazy way you mentioned above, so if there are 300k results, do you have to have 300k conditions? Give me example of a are hard coded and there is no between or anything

one condition per resultset

Oof. So you'd have to know the internal IDs and the order pretty much. and if there are 300k results in query, the first could have 0 and the last could be 900000

as an example, if the first result sets greatest internal id was 5712, than the second id filter would be id greater than 5712

True. Man, would be a lot simpler if they'd just let you pull more than 5000 or 1000 at a time

can't you just do something like this?

function getAllQueryResults(rootQuery) {
	var pagedData = rootQuery.runPaged({ pageSize : 1000 });

	var queryData = [];
	for (var i = 0; i < pagedData.pageRanges.length; i++) {
		var currentPage = pagedData.fetch({ index : i });
		var currentPagedData = currentPage.data;
		
		var results = currentPagedData.results;
		for (var j = 0; j < results.length; j++) {
			queryData.push(results[j].asMap());
		}
	}

	return queryData;
}

Yeah, that's basically what I did. I was hoping to get larger than the 1000 page limit, because doing that pull 300 times vs 1 time or 10 times is going to take a lot longer