SET UP SQL TIME OUT from SC MACROs

[maximnl]

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);

[ISS_Pfeiffer]

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

[maximnl]

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

[bwalujo]

I ran into this issue. I ended up creating my own connection to the database and execute the query or stored procedure via pdo command

I posted what I did here

Adaptive server timed out and workaround

Just wondering if anyone has run into this issue when running query longer than 30 seconds. the database is Microsoft SQL server. I’m using a blank application, in onExecute I put the following: sc_exec_sql(“query that runs a little over 30 seconds”); the result is adaptive server timed out workaround, I made my own connection: $pdo = new PDO(“dblib:host=$host;dbname=$dbname”, $username, $password, array(PDO::ATTR_TIMEOUT => 120)); $sth = $pdo->prepare(“same query above”); $sth->execute(…