This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

For reference, querying what are supposed to be the equivalent tables/views:

i just tested these same queries and got similar results. i've not done any extensive benchmarking tests but seems to be slower on most queries.

Isn't this ridiculous <@U01RLMPHVD0>? For the newer service that we're being forced onto to be TEN TIMES slower than the existing service that we're currently using???

Absolutely. We're not sure how impactful this will be for us yet. We use a 3rd party platform called Stitch to sync data to our Redshift platform. We're going to spin up a new version soon to see how much slower it is.

considering how much slower it is, my suspicion is that they've added an abstraction layer in between. probably something like converting the SQL query to API calls.

I'm experiencing the same insanely slow query performance. For example, this query takes 30 freaking minutes with Netsuite2:

select count(*) from transaction where recordtype= 'salesorder'

lolcry

Follow-up! Query: "Pull the very first transaction ever". Here's the results for NS vs NS2 data sources: