Re: php, odbc and informix, speed problem

Posted in 2004

CKGeier@nwc.edu — Fri, 15 Oct 2004 12:16:02 -0500 — source: Usenet: comp.databases.informix

This is a multipart message in MIME format. --=_alternative 005EEFC686256F2E_= Content-Type: text/plain; charset="US-ASCII" I forgot to mention that we are also using php, along with apache. C Geier St. Paul, MN ckgeier@nwc.edu cbrunain@altern.org (Christophe) Sent by: owner-informix-list@iiug.org 10/13/2004 05:09 AM Please respond to cbrunain@altern.org (Christophe) To informix-list@iiug.org cc Subject php, odbc and informix, speed problem Hello everyone First here are the computers involved : Web server : windows 2000, apache server, php 4.3.3 ODBC version : IBM Informix Connect 2.81 Informix server : OS : UNIX system V Release 4.1 Informix version : INFORMIX-SQL Version 7.20.UD6X4 I have several php scripts that make queries on the informix server, most of the time to a table of about 1.000.000 records that contain people infos. The problem is : at the beginning of the day, all is going fine, the pages are going to the sreen fastly, and so on... During the day, the speed the pages are showing is decreasing, and at a certain time, time out... I have checked all my scripts, each time i do an open database, i do a close dtabase, the same for the queries. On the informix server, there are about 200 connections at the same time, via forms and so, and it works fine. Only the "web" part is going slower Does anyone have an idea from where it can come ? (Sorry for my bad english ...) Thanks in advance ! --=_alternative 005EEFC686256F2E_= Content-Type: text/html; charset="US-ASCII" I forgot to mention that we are also using php, along with apache. C Geier St. Paul, MN ckgeier@nwc.edu <table width=100%> <tr valign=top> <td width=40%>cbrunain@altern.org (Christophe) Sent by: owner-informix-list@iiug.org 10/13/2004 05:09 AM <table border> <tr valign=top> <td bgcolor=white> <div align=center>Please respond to cbrunain@altern.org (Christophe)</div></table> <td width=59%> <table width=100%> <tr> <td> <div align=right>To</div> <td valign=top>informix-list@iiug.org <tr> <td> <div align=right>cc</div> <td valign=top> <tr> <td> <div align=right>Subject</div> <td valign=top>php, odbc and informix, speed problem</table> <table> <tr valign=top> <td> <td></table> </table> <tt>Hello everyone First here are the computers involved : Web server : windows 2000, apache server, php 4.3.3 ODBC version : IBM Informix Connect 2.81 Informix server : OS : UNIX system V Release 4.1 Informix version : INFORMIX-SQL Version   7.20.UD6X4 I have several php scripts that make queries on the informix server, most of the time to a table of about 1.000.000 records that contain people infos. The problem is : at the beginning of the day, all is going fine, the pages are going to the sreen fastly, and so on... During the day, the speed the pages are showing is decreasing, and at a certain time, time out... I have checked all my scripts, each time i do an open database, i do a close dtabase, the same for the queries. On the informix server, there are about 200 connections at the same time, via forms and so, and it works fine. Only the "web" part is going slower Does anyone have an idea from where it can come ? (Sorry for my bad english ...) Thanks in advance ! </tt> --=_alternative 005EEFC686256F2E_=-- sending to informix-list