|
|
|
| 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 : |
4135 |
| 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(). |
|
| Forum with Access 97
Categories : MS Access, Complete Programs, PHP, ODBC, WinNT | | | Voting Machine with Access 97
Categories : PHP, ODBC, WinNT, MS Access, Complete Programs | | | This is a small Web Phone Database which is written in PHP3
and utilizes a ODBC Data Source.
Categories : PHP, ODBC | | | How to access MS Excel spread sheets from PHP
Categories : PHP, Excel, ODBC, Databases | | | db2tab.php - Simple scripts to access IBM DB2 Universal DataBase tables through PHP ODBC funtions.
Categories : Databases, PHP, ODBC | | | Modification of Shane Caraveo's guestbook. Uses ODBC...some code modifications
Categories : ODBC, Databases, Complete Programs, PHP | | | 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 | | | ADODB Database Wrapper Abstraction Library for PHP: MySQL, MSSQL,
Oracle, Interbase,ODBC, Microsoft Access and FoxPro.
Categories : PHP Classes, Databases, PHP, General SQL, ODBC | | | UDMSearch - a free search engine, indexing system.
Categories : Search Engines, Linux, PHP, MySQL, ODBC | | | 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 | | | odbc_autocommit -- Toggle autocommit behaviour
Categories : PHP, PHP Functions, ODBC | | | Recordset Class like ADO Recordset (plus DataBase Splitting feature) using ODBC functions
Categories : PHP Classes, ODBC, Databases, PHP | | | Unable to select text bigger than 4K from MSsql
Categories : PHP, WinNT, Databases, MS SQL Server | | | windows nt php/3 file upload script
Categories : Filesystem, PHP, IIS, WinNT, Web Servers | | | Query2Report : Generating Html, Pdf and Csv Reports from SQL Query
Categories : PHP, PHP, HTML, PDF, Excel | |
|
|
