NSC | SuiteQL Query: Reducing Transaction Results by Internal ID

Scenario:

Some NetSuite Accounts contain a very large number of transaction records and are sometimes advised to break the query into smaller results to avoid running into timeouts.

Solution:

Generally, users must call only the columns they need to optimize their query. They may utilize the internal ID along with operators such as less than, greater than, or equal to reduce the results. Here is a sample:

select id, lastmodifieddate, tranid 

FROM transaction 

WHERE type = 'SalesOrd' AND id < 7000;

This query will only return transaction records whose internal IDs are below 7000. It should be noted that internal IDs usually skip and therefore this does not necessarily mean that the result will return 7000 records.