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?
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.