Re: php, odbc and informix, speed problem

Posted in 2004

Topics: Performance & Tuning, Connectivity: ODBC / JDBC / .NET

Emmon Simbo — 25 Oct 2004 03:39:43 -0700 — source: Usenet: comp.databases.informix

Hi One issue here could be caching. If memory serves me right, that ODBC driver pulls data unto the client and stores it there which will explain the performance decrease. As an alternative, you could in theory try out the OpenLink ODBC drivers for Informix which uses a Managed Client to communicate with Server Side components which employ server side caching, thereby utliising the Server's own processing power. You can obtain a ful 30 day evaluation copy from http://www.openlinksw.com HTH Regards Emmon Simbo CKGeier@nwc.edu wrote in message news:<ckp1v3$p81$1@news.xmission.com>... > 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

↪ replying to Emmon Simbo

Data Goob — Mon, 25 Oct 2004 07:37:47 -0400 — source: Usenet: comp.databases.informix

I'm in the memory-leak fan club. The real problem is that you are on Windows, so you take a performance hit just for that. The next problem is that you are on an old version of Windows, an old version of PHP ( in internet time ) and an old version of Informix. Next, you're using ODBC, so take more off for that. ODBC levels the playing field and reduces peformance while making things more portable. You should see if you can't use the ifx_ functions instead of ODBC calls, as the library functions bind to the network library for Informix which should be faster. But overall it sounds like a memory leak somewhere, with the description you gave. Informix or PHP could have the memory leak. See if you can move to a Linux box and a later release of Informix, PHP, and Apache. Apache could be contributing to the leak problem too. Good Luck! Emmon Simbo wrote: > Hi > > One issue here could be caching. If memory serves me right, that ODBC > driver pulls data unto the client and stores it there which will > explain the performance decrease. As an alternative, you could in > theory try out the OpenLink ODBC drivers for Informix which uses a > Managed Client to communicate with Server Side components which employ > server side caching, thereby utliising the Server's own processing > power. You can obtain a ful 30 day evaluation copy from > http://www.openlinksw.com > > HTH > > Regards > Emmon Simbo > > CKGeier@nwc.edu wrote in message news:<ckp1v3$p81$1@news.xmission.com>... > >>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 ! >> >>