How's the performance like in the suiteQL? We are executing a simple select to the TransactionLine table

Select Id, Transaction FROM TransactionLine

limiting to 1000 records and it takes 20 seconds to execute per page. It has around 14 million records. Should we expect it to be this slow?

In my experience, SuiteQL is faster than the other search mechanisms available to script.

20 seconds for 1000 records sounds very slow

the 14 million records is a factor.

Even if fetching just 1000? Also some back of the napkin math says it will take 3 days. Is it really just unusable with that many records?

Is this slowness related with how the SuiteQL functionality works?

How are you limiting? What's your full query?