Anyone out there using SuiteQL via REST? I'm wondering how long a query like this

SELECT COUNT(*) FROM transactionaccountingline GROUP BY 'nothing'

takes in ya'll environments. For me it takes about 1s, but I am testing on a sandbox account with limited data. Does anyone of a ton (millions or billions) of transactions in their NetSuite account? Curious how long this query takes

@Marc Reicher In a production account with 8.2 million records in the transactionaccountingline table, I get the response back in under a second.

Wow interesting. Really wonder what’s going on under the hood there

Unfortunately, we don't have a lot of visibility at this point. As a result, tuning queries is often trial and error. I have found that using SuiteQL via a RESTlet is usually much faster and easier to work with than using it via SuiteTalk REST.

Yup makes sense, though is very frustrating. Unfortunately, getting RESTlets involved requires a ton of overhead for my company and is usually a last resort. That's good to know though