View Single Post

   
  #3 (permalink)  
Old 04-29-2008, 08:26 PM
Christian Welzel
 
Posts: n/a
Default Re: express-c and php very slow

Hi Dave,

> I'd hazard a guess that
> your PHP app is the only thing connecting to the database?


Yes, it is.

> I'd also guess that
> you're not using connection pooling / persistent connections?


Correctly. I dont know if the php-db2-driver supports this, but i
investigate this.

> 2) A better idea is to change the application to use persistent
> connections / connection pooling. However, before doing that I'd use
> ACTIVATE DB just to see if this is actually what the problem is.


I activated the database and now the requests are handled very
fast. Seems this solved my problem at a first step.
As we are in a very early state of development, this solution is
ok for me, but for later use i will look for some pooling code
as you suggested.

--
MfG, Christian Welzel aka Gawain@Regenbogen

GPG-Key: http://www.camlann.de/key.asc
Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
Reply With Quote