Re: php, odbc and informix, speed problem

Run the task manager on the Windoze box, and see what is getting slower, I'd look for a leak, there are a number of free utilities that should allow to check for this. Christophe wrote: > > 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 ! -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #