Hi,
I can use some help working with the rest API queries and a slowness issue.
Many of my queries happen quickly with no problems, however some of them are quite slow or seem to never complete.
-> note: I do understand that select all "*" is a waste of resources and will slow down the process. Soon I will simply select the proper individual fields only. But for now, I will show you this...
Also using limit=5 for now
https://xxx.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=5
Question: is there a different way to query these SQL so it can work better / faster
As an example:
this is slow but works:
{"q": "SELECT * FROM transactionline tl, transaction t, customer c WHERE tl.linelastmodifieddate > '1/1/2021' and tl.transaction = t.id and t.entity = c.id"}
this is very slow and seems to not complete (w / subsidiary):
{"q": "SELECT * FROM transactionline tl, transaction t, customer c, subsidiary s WHERE tl.linelastmodifieddate > '1/1/2021' and tl.transaction = t.id and t.entity = c.id and s.name LIKE '%AAAAA%'"}
Thanks for the Help - dave