Solved

PowerBuilder / SQL Server 2000 Performance Question

Posted on 2006-07-06
4
520 Views
Last Modified: 2013-12-26
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.

Thanks!!

PEM
0
Comment
Question by:pemurray
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 

Author Comment

by:pemurray
ID: 17063382
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?

Thanks!!

PEM
0
 
LVL 4

Accepted Solution

by:
batchakamal earned 500 total points
ID: 17092923
Use SetTransPool function

SetTransPool(10,10,10)

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

It supposed to be

SQLCA.Lock = "Exclusive"
SQLCA.Autocommitt = True
0
 

Author Comment

by:pemurray
ID: 17093556
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?

Thanks!!

PEM
0
 

Author Comment

by:pemurray
ID: 17095405
Batchakamal,

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:

server_app.SetTransPool(12,16,10)
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question