Re: PHP CGI speed problem

I'm assuming you mean your writing PHP code and running PHP as a CGI. If this is correct, perhaps there is a leak in your code somewhere, maybe a loop that is not supposed to be (but is) growing steadily in number of iterations? Are you sure it's not your Postgres DB causing the bottleneck? I have seen it where when you insert large volume after volume of text, where Postgres will slow down to a crawl until it does something like Vaccum the DB or whatever it does to clean it up. Adam Voigt adam.voigt@cryptocomm.com On Tue, 2002-10-22 at 09:27, Thuy Nguyen wrote: > Hi, > > I am writting CGI in PHP to register text data into Postgres DB. Because the > amount of data is very large, it will take about 20 days. So, I would like > to make my CGI run 20 days straight (none spop). However, when it passed 5 > hours, it is getting slower. It transfered about 400 records per hour at > beggining and now it transfere only 10 records per hour. > > Does anybody know, what do I miss, and how do I fix it? > > >