Oracle BTS integration: PConnet or NConnect

agarg2 · Post by **agarg2** » Thu Feb 14, 2008 11:16 am

Hi,

After a minimal set of changes finally I was able to configure TestLink to work with out internal oracle based BTS system.

But I observed after the integration, TestLink performance went down drastically. After digging up ADODB/TestLink code, I found out that in TestLink the code is written to use NConnect instead of PConnect. This causes TL to re-connect to BTS every time instead of using persistent connection.

After changing the call to PConnect in database.class.php and bit of modification in int_bugtracking.php, I was able to get pretty good performance.

So is there any specific reason for not using PConnect in TestLink? I just want to make sure PConnect will not cause any issues.

Regards,
Arun Garg

Post by **fman** » Thu Feb 14, 2008 3:39 pm

AFAIK, we have problems with P connect when connecting to TL and BTS with SAME DB TYPE. ie both using MySQL

agarg2 · Post by **agarg2** » Fri Feb 15, 2008 9:04 am

Thanks for the quick reply. If possible, could you please share what kind of issues team faced with PConnect (with MySQL DB)? Also did you discuss the issue ADODB team and get any reply from them?

The reason I am asking all these questions because without PConnect my TestLink set-up just crawl so I would like to go for PConnect and at the same time want to make sure it does not break anything in TL.

Regards,
Arun Garg