Here's the scenario: A php application that is basically a query generator. The local webserver runs off of MySQL but the query being generated is sent to a large Sybase data store. Sybase executes a stored procedure and returns results. The results are stored in MySQL.
The problem: The sybase queries are sometimes taking 5 minutes (the data store is huge). There is a new window that launches the query builder component. I want to close the window in which the query was built and get the return results "in the background" where they will be inserted into the local MySQL database. The thought is that the user should be able to build a new query while the other one is running.
I've tried closing the window first (with javascript) and then executing the sybase commands to do the query. However, it doesn't close the window until after the results are gotten (out of step). What's going on?
Does Apache not allow for a PHP script to run without an associated client window? Would sending the request via POST or GET make a difference in how I send the data to my script that sends the data off to Sybase?
I've thought of having a hidden frame or window somewhere that would call the PHP script but that seems kind of weird. I would POST to the hidden frame and it would send the data off to Sybase.
