Hello, I am using POSTGRESQL Version 7.1.3 and PHP to implement a call center software. We have real -time updations and querying on the database almost every 30 seconds. I am using PEAR DB to realize data abstraction layer. I am regularly doing VACUUM ANALYZE. I don't know what is making the system to be very slow, but it takes nearly a minute plus execution time to do simple fetch operations. How do I make the system, to perform much faster. Sometimes I also get the following error.. ------- ERROR STARTS------ Fatal error: Maximum execution time of 30 seconds exceeded in DB/pgsql.php on line 163 ------- ERROR ENDS------ -- Best regards, Gurudutt mailto:guru@xxxxxxxxxxxxx Life is not fair - get used to it. Bill Gates
