|
|
Posted by gj on 08/21/06 08:03
Hi all,
I am currently trying to setup a query tool for our in-house database,
Navision, using PHP and ODBC. So far, no problem.
However, I find that there are certain queries taking longer than the
maximum execution time of the script itself, leading to timeouts, even when
I replace "SELECT * FROM ..." with the specific fields I am looking for
(example: 'SELECT Name, Number, Telephone FROM Customers' instead of 'SELECT
* FROM Customers').
Moreover, the Navision ODBC link does not support a LIMIT clause, and it
insists on collecting a complete recordset before returning.
Short of extending the timeout in php.ini, or making users wait for what
seems like ages, I would like to know if the following is possible, and if
so, how to go about it:
1. Is there a way to execute an OBDC query asynchronously ? I.e. I can show
a page of records while the rest is still being fetched ?
2. Failing (1), is there a way to emulate a limit clause ? This would only
solve the 'paging' problem, not the initial query time.
I have already experimented with cached result sets (with serialize to file
etc.), but this would invalidate the 'real time' factor I'd like to have.
I am running PHP 5.1.4 on IIS (Windows XP) on my development box.
Any information or pointers to a possbile solution would be appreciated.
Kind regards,
Wef.
Navigation:
[Reply to this message]
|