2. PHPRunner General questions
  3. Query Time outs - multi-stage processes
This topic is locked

Query Time outs - multi-stage processes

 		8/6/2015 6:36:27 AM
PHPRunner General questions
B
 bobr666 author

I am working with quite a complex database processing system. Quite a few of the processes involve a number of SQL Server stored procedures. e.g. creating temp tables etc.

  1. How can I adjust the time out? Some of the queries run fine if I run them on the server itself, but they time out if I run them in PHPRunner. I am running PHP Runner 7.1 on XAMPP with SQL Server - how can I extend the time out?
    Source: Microsoft OLE DB Provider for SQL Server

    Description: Query timeout expired
  2. I have split some of the multiple stage processes into several manual steps in PHP Runner - can you suggest a "best practice" way to do this (the app currently uses menu items) to ensure they are all run, and in sequence?
    Bob
D
 		DealerModulesDevClub member 8/7/2015

Hi Bob,
This page may be worthwhile... http://us.php.net/set_time_limit
Also...
How to increase PHP session timeout.
In php.ini file find session.gc_maxlifetime variable and set session expiration time in seconds (3600 means one hour).
session.gc_maxlifetime = 3600
Hope this helps.
Paul