Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Databaseconnections

Status
Not open for further replies.
axehigh

axehigh

Programmer
Aug 16, 2007
1
SE
Hey guys.

I have a question about Powerbuilder 10.5.1 build 6602.

How many database connections can I use.

We are in the process of splitting up a large Oracle Schema into different databases and schemas - and I was wondering what issues I can run into..

Thanks
 
Sort by date Sort by votes
I'm not sure of a maximum number of connections but I have used up to four concurrently.

Matt

"Nature forges everything on the anvil of time
 
Upvote 0 Downvote
Hi,

You can have many transaction objects pointing to each database respectively. But just make sure that it is not impacting performance.

If you want many transaction object ( say > 10) then create only few of them as global transaction object apart from SQLCA and rest can be created and destroyed as and when required. Assign most freqently accessed database to SQLCA.

Regards,
Abhijit.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top