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

Resolved Very slow Update()

  1. How-to
0
Votes
Undo
  1. Eduardo G.
    Eduardo G.
  2. PowerBuilder
  3. Thursday, 15 February 2024 10:18 AM UTC

Good morning,

I have a problem that is happening with PB 2022 R3 Build/Runtime 3289.

I have a DW created with SyntaxFromSQL that inserts 40,000 new rows, when I run dw_1.Update() it takes almost 2 minutes to finish, in PB 2022 Build 1892 performing dw_1.Update() is instant.

I made changes in the way of generating the DW syntax and it still takes a long time.

Does anyone have a solution, what has changed in this new version to make this happen, please I need your help.

Thank you very much.
Eduardo G.

Connecting to Hadoop impala Database from Powerbui...
To open a window as reponse as well as main window
Accepted Answer
Eduardo G.
Eduardo G. Accepted Answer Pending Moderation
  1. Tuesday, 5 March 2024 09:13 AM UTC
  2. PowerBuilder
  3. # Permalink

Hello everyone,

First of all I want to thank you for all the advice and help for all the answers to my problem.

The slowness of dw_1.Update() which internally throws 40,000 INSERTs per record to the Oracle server and takes +- 2 minutes is due to the ongoing implementation of security systems in the company network. The Oracle administrators launched the sencias with a log control and it took 30 seconds.

Thank you all for your help.

Comment
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Tuesday, 5 March 2024 15:14 PM UTC
Ha Ha, Fecking DBAs always doing stuff that is not appropriate.... LOL!
  1. Helpful
There are no comments made yet.
Responses (5)
Eduardo G.
Eduardo G. Accepted Answer Pending Moderation
  1. Friday, 16 February 2024 10:07 AM UTC
  2. PowerBuilder
  3. # 1

Thank you all for your help, I will pass on what is happening to the Oracle database manager to check if there is any reason why the INSERT is not as optimal as in previous occasions.

 

Comment
There are no comments made yet.
Eduardo G.
Eduardo G. Accepted Answer Pending Moderation
  1. Thursday, 15 February 2024 13:22 PM UTC
  2. PowerBuilder
  3. # 2

With Accessibility=0 OR Accessibility=1 I got the same result 2 minutes +- time to run dw_1.Update()

I performed a Migrate and Full Build with Runtime 22.0.0.1892 and I have the same result, with these tests I understand that it is an error of the R3

Comment
Andreas Mykonios
  1. Andreas Mykonios
  2. Thursday, 15 February 2024 15:44 PM UTC
You put it in [Application], right?
  1. Helpful
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Thursday, 15 February 2024 12:33 PM UTC
  2. PowerBuilder
  3. # 3

There is a change in PB 2022 R3 that may affect your application... Take a look at the link: Accessibility improvements - - What's New (appeon.com).

So check if something that relates with accessibility option affects PB 2022 R3 performance.

Andreas.

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Thursday, 15 February 2024 10:30 AM UTC
  2. PowerBuilder
  3. # 4

Hi.

I would start by comparing the generated dw syntax from pb 2022 r2 1892 to the one generated with pb 2022 r3.

Andreas.

Comment
Load more comments
Eduardo G.
  1. Eduardo G.
  2. Thursday, 15 February 2024 12:57 PM UTC
Oracle 12.1.0
  1. Helpful
mike S
  1. mike S
  2. Thursday, 15 February 2024 14:01 PM UTC
"SyntaxFromSQL "

do timing checks before and AFTER the create from syntax is done. Oracle can be extremely slow in providing the information on tables when creating a syntax from sql. It is possible that the performance issue is in that.
  1. Helpful 1
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 15 February 2024 15:53 PM UTC
Good point Mike.

I would also check with your DBA team to see what might have changed.

Also, Oracle runs slower & slower as the DB Log(s) fill up. DBA might need to perform a "Truncate Log" etc in order to speed up the DBMS server.
  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.