Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PB 11.5 application slows down if another Sybase application is running

  1. How-to
0
Votes
Undo
  1. Tomas Beran
    Tomas Beran
  2. PowerBuilder
  3. Monday, 9 September 2019 17:43 PM UTC

Hello

I've met a strange issue with PB 11.5 and another Sybase product like dbconsole.

Everytime I start dbconsole. (simply starting without any connection is enough). Then my PB app slows significantly. Especially constructors of objects containing datastore are affected by this problem.

In attached picture you can see creating of 6 datastores as NVO with dataobject already set in the painter and calling SetTransObject(SQLCA) for them.

I absolutely don't understand why. I think there's such connection between Sybase apps like shared DLL or DDE etc. across the whole OS. But I can't catch it.

 

My setup:

PB 11.5.1 5097

Sybase SQL Anywhere 11.0.1.3113

Windows 10 build 1903

I use PFC and Powertools but I think it's irrelevant to the issue.

You can see the issue in the attached profile result picture. Whole 1 second just disappeared during the object creation.

Do you have any idea how to solve it?

Attachments (1)
asa_bug.jpg asa_bug.jpg
Como Exportar un datawindow en formato XML estánda...
switching from landscape to portrait unwanted
Responses (2)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 9 September 2019 21:41 PM UTC
  2. PowerBuilder
  3. # 1

Another thing: could it be the database that slowing everything down?

You have datastores....what are the retrievals like for eash DS. Are there other database operationa occurring during the open and subsequent processing?


Olan

 

Comment
Tomas Beran
  1. Tomas Beran
  2. Tuesday, 10 September 2019 09:24 AM UTC
Hi

it's not possible because PB is single threaded and I don't use the 'cheat' with SetMicroText hooked at retrieverow event because PB instantly crashes when more than one retrieve is running.

So no, there's no paralel retrieve running.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 9 September 2019 19:41 PM UTC
  2. PowerBuilder
  3. # 2

Hi Tomas;

   I wonder if you have the DBConsole App set to "Auto-Trace" and whether your Trace Settings are trying to trace way too much App resource wise?

FYI: https://wiki.scn.sap.com/wiki/display/SQLANY/Performance+and+Tuning

HTH

Regards ... Chris

Comment
Tomas Beran
  1. Tomas Beran
  2. Tuesday, 10 September 2019 10:09 AM UTC
I used DBConsole just as an example of this bad behavior. My DBConsole isn't connected to any database. So it can't turn on any tracing. Simple opening the dbconsole empty window is enough. Just opening Scjview (Sybase Central) or dbisql (SQL Interactive) slows down PB apps too.

The issue is limited to ASA 11. ASA10 was OK. And ASA17 is OK too. But if I connect my PB app to ASA11 using ODBC driver from ASA 17 then the app is affected too. Therefore I think dbclient is not the source of the issue.

I checked communication through process explorer and there's just communication to the database server. There's no additional listener etc.



Thinks I suspect are:

- Broken Java engine itself

- Mutexes, semaphores, Namedpipes, DDE, shared DLL or any other form of direct communication between processes.

- Problem in msvcrt, gdi+ etc.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.