PHP ODBC AS400 - When running query new connections to site cant be opened.
Posted on 2009-04-27
Runing Zend/IIS/PHP I have a program that will connect out to our AS/4000 to do some budget cals, however when this is running on the as/400 it prevents any one from accessing the website until the query is done on the as/400 which can be upto 15min.
User 1 goes to website and starts the budget calc process, User 2 tries to load up the website but cant, basically will sit there waiting for the connection until it times out or User 1's calc finishes and then User 2 can get to the website.
I have mysql queries that take 20min to run and people are able to access the site just fine, only happening when I connect out to the as/400.