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

Resolved Switching to Data Source is very slow

  1. Issue
0
Votes
Undo
  1. Dick Alstein
    Dick Alstein
  2. PowerBuilder
  3. Monday, 11 February 2019 13:22 PM UTC

Hi,

When I am editing a datawindow in the IDE and switch from design mode to the Data Source, it takes a very long time. It might take 3 minutes or more for the SQL query to be displayed, which is harmful to the speed of development.

This may have something to do with the data model being very large (around 1000 tables). Sometimes, the wait time is much smaller (10 seconds or so), in the quiet hours when there are few developers accessing our Oracle server. It does not depend on the size or complexity of the query.

Does anybody know what factors influence the wait time? Are there any settings that can be tweaked? It would be a huge time-saver for my team.

Datawindow Query Mode throws error
Select a printer tray using code
Responses (3)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 11 February 2019 14:27 PM UTC
  2. PowerBuilder
  3. # 1

I have the same issue with PB 12.5 and ODBC connection to SQL Server.

Comment
There are no comments made yet.
Pierre Couvreur
Pierre Couvreur Accepted Answer Pending Moderation
  1. Monday, 11 February 2019 15:19 PM UTC
  2. PowerBuilder
  3. # 2

Hi,

We are facing the same problem since we upgraded from Oracle 10 to 12 two or three years ago. As far as I know, there is unfortunately no solution !

https://community.appeon.com/index.php/qna/q-a/very-slow-to-open-datasource-painter?errorcode=login_failed

Pierre

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 11 February 2019 21:22 PM UTC
  2. PowerBuilder
  3. # 3

THis is not a PowerBuilder issue, it is an Oracle issue.

 

When Oracle went from 10 to 12C, this issue cropped up in a variety of ways.

1) In the Database Painter: the first time you connect to any table takes a LONG time. After the first connection is made, you can select another table and return to the original one and the table to which you connected earlier will now connect quickly.

2) Item #1 above also occurs when you run SQL in the ISQL Session frame. The first time that SQL runs it's connecting to the table(s), and that first connection takes time. Subsequent runs of the SQL proceed at a normal pace.


3) And yes, when you switch from Design to Source mode in the DataWindow Painter, the same thing happens.

I know of no work-around for this issue.


Olan

 

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