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