It occurs to me that there may be one way of using “SQL” - or at least the underlying microcode functions - without changing all the logic. Just change the program to read a logical that converts the packed values to a more efficient format. If there are no decimals then binary is an option, otherwise float or Zoned. No idea how much difference it would make but it might be worth a try since the logical is quick and easy to build.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Feb 18, 2015, at 4:39 AM, Jevgeni Astanovski <jevgeniast@xxxxxxxxx> wrote:



With so few specifics of the scenario, the following may be way off the
mark, but as a possibility:

Perhaps the /calculations with packed decimal/ over data that is
apparently /record data/ of /some tables/ could be performed by the SQL?

--
Regards, Chuck
--
Chuck,

As I wrote, I have a working functionality written on C. It works fine and fast.
Definitely C++ plus SQL will not be faster as there is a significant
amount of optimization in the current code.
SQL would do nothing more but introduce another language.
For the same price I could (in theory) consolidate all packed decimal
calculations in one module, compile it with C compiler and then bind
together with C++ main. But in my particular case it has absolutely no
sense :-)

Jevgeni.
--
This is the Bare Metal Programming IBM i (AS/400 and iSeries) (C400-L) mailing list
To post a message email: C400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/c400-l
or email: C400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/c400-l.



This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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 here. If you have questions about this, please contact [javascript protected email address].