|
|
|
| Title : |
Time out when trying to get some data out of a big table
in a large relational database. |
| Categories : |
ODBC, WinNT, PHP |
Ulf Wendel |
| Date : |
May 01st 1998 |
| Grade : |
4 of 5 (graded 2 times) |
| Viewed : |
3449 |
| File : |
No file for this code example. |
| Images : |
No Images for this code example. |
|
| Search : |
More code by Ulf Wendel |
|
| Action : |
Grade This Code Example
|
|
| Tools : |
My Examples List |
|
|
|
|
|
|
I use PHP3 RC4 with Win NT 4.0 SP3, IIS, Access 97 and an ODBC Driver).
I'm trying to get some data out of a table in my database. The table has
18 fields (4 of them with a relation to another table) and approx 60
rows. When I call the Webpage PHP tell's me : "<b>Warning</b>: PHP Timed
out!<br>".
When I reduce the number of rows to approx 10 everything works fine.
looking in php3.ini and setting the max_execution_time from 30 to 60
didn't help.
looking for php3.ini with print get_cfg_var("cfg_file_path"); to make sure
I'm reading the right php3.ini and setting the max_execution_time to 0 (which
means it's unlimited) didn't help.
It turned out that It was on the side of Access/Windows. The ODBC Driver was
leaking out of memory. But instead of producing a helpful error message it
seemed to have stopped working...
Setting up the "MaxBufferSize" for the Access ODBC Driver helped. A clear
message appeared. So I could understand the problem and solve it by using
odbc_free_result(). |
|
| Voting Machine with Access 97
Categories : PHP, ODBC, WinNT, MS Access, Complete Programs | | | Forum with Access 97
Categories : MS Access, Complete Programs, PHP, ODBC, WinNT | | | This is Yet Another Sql Abstraction Library. Include it in your script and you can use the most important SQL functions without worrying about the SQL backend.
Categories : Databases, PHP, ODBC, MySQL, PostgreSQL | | | A very simple database abstraction layer for the PHP 3.0 ODBC module.
Categories : ODBC, PHP | | | A set of functions sitting on top of the abstraction layer that makes it a little easier to do SQL stuff. Documentation is within
Categories : Databases, ODBC, Complete Programs, PHP | | | UDMSearch - a free search engine, indexing system.
Categories : Search Engines, Linux, PHP, MySQL, ODBC | | | Class to convert any document, that can be read by MS Word, to another format supported by Word.
Categories : PHP Classes, PHP, Windows 2000, Microsoft Word, WinNT | | | odbc_autocommit -- Toggle autocommit behaviour
Categories : PHP, PHP Functions, ODBC | | | windows nt php/3 file upload script
Categories : Filesystem, PHP, IIS, WinNT, Web Servers | | | How to access MS Excel spread sheets from PHP
Categories : PHP, Excel, ODBC, Databases | | | How to connect to MS SQL 6.x+ database server via ODBC functions of
PHP3 compiled with iODBC and Openlink drivers under Linux.
Categories : Databases, MS SQL Server, PHP, ODBC | | | This is a small Web Phone Database which is written in PHP3
and utilizes a ODBC Data Source.
Categories : PHP, ODBC | | | Dynamic WHERE CLAUSE depending on number of FORM FIELDS
Categories : ODBC, General SQL, PHP, Complete Programs, Databases | | | Query2Report : Generating Html, Pdf and Csv Reports from SQL Query
Categories : PHP, PHP, HTML, PDF, Excel | | | Modification of Shane Caraveo's guestbook. Uses ODBC...some code modifications
Categories : ODBC, Databases, Complete Programs, PHP | |
|
|
|
