Thanks.
I was exceeding the usage limit in a suite...
# suitescripta
Alan Fitch
08/19/2021, 2:58 PMThanks.
I was exceeding the usage limit in a suitescript because of a suiteql query I ran every line of a file so I constructed one ginormous query with hundreds of OR clauses. Am I a clown or is this a common pattern?
b
battk
08/19/2021, 3:10 PMdepends on the query
battk
08/19/2021, 3:11 PMusually you do something like use the in operator
a
Alan Fitch
08/19/2021, 3:11 PMI need it because of like.
Alan Fitch
08/19/2021, 3:11 PMLIKE sql operator.
s
stalbert
08/19/2021, 3:14 PMsounds like a tough query
b
battk
08/19/2021, 3:17 PMi dont think you can use
inlikea
Alan Fitch
08/19/2021, 3:18 PMHence the OR as I outlined in my question.
Alan Fitch
08/19/2021, 3:24 PMWill a bigger query use more usage units?
s
Sandii
08/19/2021, 3:29 PMThe query size should not matter, the number of the results matters (in search) if you are using
runPaged().fetcha
Alan Fitch
08/19/2021, 3:30 PMwhat about
asMappedResults()s
Sandii
08/19/2021, 5:25 PMyou can look at the help documentation, it tells you how many governance units each call uses
Sandii
08/19/2021, 5:26 PMIf the documentation is not clear, then you check in your script with runtime and getting the current script
a
Alan Fitch
08/20/2021, 7:13 PMApparently as long as I want. Only 10 units. Pretty cheap if you ask me.
4 Views