Use pages and a foreach.
# suitescriptk
karlenigma
11/02/2018, 5:47 PMUse pages and a foreach.
a
andy.crumrine
11/02/2018, 6:27 PMI’m kind of limited by my integration, but I used the following method:
• Initial request, ran the search in pages and cached 10 pages worth of results
• Next 10 requests returned each page
• Repeat until all pages returned.
I found that this process was only a little faster than running the search every time and returning one page at a time.
andy.crumrine
11/02/2018, 6:29 PMI’m actually limited to returning only 500 results at a time
andy.crumrine
11/02/2018, 6:30 PMCaching is quicker than rerunning the search over and over, but it’s not as quick as it could be.
k
karlenigma
11/02/2018, 6:38 PMI know I used a page range method that returned 5000 lines at a time. But could of return a he'll.of a list more. I was processing 8million records.
b
borncorp
11/02/2018, 7:30 PMYou can have the search running every 15 mins and caching the results in the file cabinet, you would sacrifice real time results but it would be a lot faster.