SET UP SQL TIME OUT from SC MACROs

Hi
i was wondering if anyone experienced time outs while running a long query or stored procedure using a macro?
i noticed that a grid app has a time out setting. so there is a something to set it up.

however if you use SC_LOOKUP macro you might get over timeout. In my case, the called procedure just brakes, doing only the first part of the sql script. i notice it works up to 40 sec, but if you wait longer , SC_LOOKUP will brake. also sc_exec_sql($update_sql);

40 s for a lookup is extremely long. You have no idea with indexing or other tricks to downsize this duration ?

1 Like

In my case, lookup method is calling a stored procedure that does a lot of heavy data processing and returns the results.