I have a restlet that runs a query and returns the...
# suitescripte
ericbirdsall
03/20/2025, 5:02 PMI have a restlet that runs a query and returns the results as a JSON object.
The first time I run it, the response takes 20seconds.
Everytime I run it after (results don’t change) it takes 8 seconds.
Anyone know why this would happen?
a
Anthony OConnor
03/20/2025, 5:17 PMlow level of certainty on this but I'd assume NS is caching the results or something in the SQL DB
☝️ 1
j
jen
03/20/2025, 5:20 PMYeah I’ve noticed similar. I think there’s definitely some caching going on with queries.
e
ehcanadian
03/20/2025, 5:22 PMMy guess is Oracle's SQL result cache. There are a few questions about it on SO.
s
Shawn Talbert
03/20/2025, 5:38 PMalso presume the optimized query itself is cached for some time after initial run
a
Armanda
04/22/2025, 1:38 AMHi Eric,
I want to ask, where do you call restlet from? Is it from suitescript too or from Postman?
s
Shawn Talbert
04/22/2025, 4:27 PMFWIW, for development/testing we use playwright.dev to test restlets.
e
ericbirdsall
04/22/2025, 5:29 PM@Armanda I was testing with Postman
a
Armanda
04/23/2025, 4:55 AMOkey Thanks, Are You Know how to call Restlet form another SuiteScript with Auth Headers ? or form another Script outside Netsuite