• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

PowerBuilder / SQL Server 2000 Performance Question

Greetings All,

I have a very small application that I am rolling out to about 6 agents.  When it starts, it hits the database and pulls up 18 rows to view standing orders.  There are about 6K rows in the table that I am hitting.

The 3 installs went fine.  The users on 4th, 5th and 6th installations could not get the application to run.  Just an hour glass.  A few minutes, eveyone (using another application that hits the same database) got runtime error 462 and we had to reboot the database.

The manager of the group told me that they started getting the error the day before, so I don't think it was my app (alone).

These are fairly simple queries.  The SQL was automatically generated from the where clause that I used in the datawindow.  Each installation uses a system DSN (which is also used by another reservation system).

Question: Could the PB application be conflicting with the DSN that is in use by the reservation system?  Obviously the user can only use one application at a time.  There is no timer event that would cause my application to refresh by itself.

I thought maybe sql server does not have enough memory, or perhaps there are not enough licensed connections?

Any advice here would be very help.


  • 3
1 Solution
pemurrayAuthor Commented:
One more thing...

I realized that I did not have code in the application close event to 'disconnect' from the database.

Would that cause a serious problem?


Use SetTransPool function


and before connecting to the database, check your AutoCommitt and Lock.

It supposed to be

SQLCA.Lock = "Exclusive"
SQLCA.Autocommitt = True
pemurrayAuthor Commented:
Greetings Batchakamal,

I forgot to mention that the application also does inserts and updates to the database.

Is the code above still okay?

Does it all go into the application open event?


pemurrayAuthor Commented:

My application is a client/server application.  Not a distributed application.  Does SetTransPool still apply?

From PB Help:

A distributed PowerBuilder server application that services a high volume of short database transactions to the same data source could issue the following statement in its application Open event:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now