Hello. I'm creating application with REST WebService, that using SuiteQL.
Currently i'm trying to optimize processing speed. I'm see, that some queries executes slow.
This is some examples of my queries. Is this normal speed for SuiteQL?
1) Take one quote (select t.*, to_char(t.createddate, 'yyyy-mm-dd HH24:MI:SS') datecreated, to_char(t.lastmodifieddate, 'yyyy-mm-dd HH24:MI:SS') datemodified, c.displaysymbol from transaction t join currency c on c.Id = t.currency where t.type = 'Estimate' and t.number = 85) – 4.76s.
2) Take list of 65 quotes (select t.*, to_char(t.createddate, 'yyyy-mm-dd HH24:MI:SS') datecreated, to_char(t.lastmodifieddate, 'yyyy-mm-dd HH24:MI:SS') datemodified from transaction t where t.type = 'Estimate' and t.custbody_wex_customerid = 161 order by t.number desc) – 6.92s.
3) Take one item (select item.*, p.unitprice, c.name as instrument_type, item.custitem_wex_instrument_type type from item join pricing p on p.item = item.id join customrecord_wex_categories c on item.custitem_wex_instrument_type = c.id and p.currency = 1 and p.pricelevel = 1 and isonline = 'T' and item.id = 108) – 4.72s.
4) Take list of 1000 items (select item.*, p.unitprice, c.name as instrument_type, item.custitem_wex_instrument_type type from item join pricing p on p.item = item.id left join customrecord_wex_categories c on item.custitem_wex_instrument_type = c.id and p.currency = 1 and p.pricelevel = 1 and isonline = 'T') – 4.10s.
Also, i'm see, that every first query to table in session is extremely slow, sometimes execution time raises to 15-20s. Is this ok?