Perfomance issue

[GoogleCodeExporter]

Hi,

I'm working on a Django web application that use a DB2 database.

In a test environment we have the application deployed under Apache2+wsgi on 
Windows 2008 server sp2 host.

Making a load test:
 - with PCONNECT=True: 
     after 10 virtual concurrent users the error occurs:
     [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010"
 - with PCONNECT=False:
     no errors occurs but the performance are very poor.

Any suggestion is greatly appreciated.

Thanks
 Serafino

Original issue reported on code.google.com by s.bera...@k-tech.it on 11 Jul 2012 at 1:56

[GoogleCodeExporter]

Persistence connection should not be done in multi-threaded scenario. 
PCONNECT flag should be False for that. If you ar getting very poor performance 
then please activate your Database by using following command of DB2 Server 
"DB2 activate db db-name", we will defiantly get some performance benefit.

For more performance enhancement please look for any connection pooling 
application which can be used with Django.   

Original comment by rahul.pr...@in.ibm.com on 12 Jul 2012 at 8:29

[GoogleCodeExporter]

Thank you for informations and suggestions,

do you think that an Apache prefork installation on a linux box with 
PCONNECT=True will solve both Performance and Stability problems?

Thanks
 Serafino

Original comment by serafino...@gmail.com on 12 Jul 2012 at 11:08

[GoogleCodeExporter]

Hi Serafino,
 You will get the performance and stability through prefork, But you should limit the parallel running process up to the limit which you wants parallel connection.

In this case also please activate the database.

Original comment by rahul.pr...@in.ibm.com on 12 Jul 2012 at 11:17

[GoogleCodeExporter]

Original comment by rahul.pr...@in.ibm.com on 5 Sep 2012 at 6:59

• Changed state: Done