×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
+1 on working with data sets!
On Tue, 20 Aug, 2024 at 10:17 AM, Daniel Gross <daniel@xxxxxxxx> wrote:
To: rpg programming on ibm i
Hi Marco,
Am 20.08.2024 um 16:50 schrieb Marco Facchinetti <marco.facchinetti@xxxxxxxxx<mailto:marco.facchinetti@xxxxxxxxx>>:
Hi all, I'm talking about embedded SQL.
execute the following code 1.260 times:
<snip>
Takes 2/3 seconds.
Executing 1.260 times any variation of these 4 statements (the last one is the cursor's code):
<snip>
You can try the statements in iACS and look, what Visual Explain says about them. Sometimes the problem is a missing index - sometimes something that makes it impossible to cache the access plan or result.
But first, you should think about the application logic - repeating a SQL statement (or a whole SQL cursor loop) for over 1.000 times is a big no-no.
To utilize the full power of SQL you should think about "data sets" and how the a linked together - maybe you can join the data to another table - so that you don't have thousands of open/close operations or select-into statements.
So rethinking the application design might be a good idea - from this very restricted point of view.
HTH
Daniel
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
