1. Tomas Beran
  2. PowerBuilder
  3. Monday, 09 September 2019

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)
Olan Knight Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Tomas Beran
  2. Tuesday, 10 September 2019
There are no comments made yet.
  1. Monday, 9 September 2019
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Tomas Beran
  2. Tuesday, 10 September 2019
There are no comments made yet.
  1. Monday, 9 September 2019
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.