Re: the advantages of garbage collection

What if you're trying to sort the results of a webservice call? Or the data

in an XML table? Or even merging and then sorting the data from a "join"
between data in i, data in SQLServer and data from a webservice call?

But now we are talking about a VERY small part of a larger ERP application.
I guess I should have declared my comments to be directed towards the kind
of core blackbox processing one would find everywhere in an application vs.
the fringe feature sets or integration points.

On the note of web services, depending on the importance of the data and
having record of the transaction, I usually write the XML content out to a
DB2 table anyways. Taking that route I have a much more stable state of
everything vs. building everything into an applications memory
infrastructure which is much more difficult to debug IMO.

Aaron Bartell
http://mowyourlawn.com


On Mon, Jun 23, 2008 at 9:28 AM, Walden H. Leverich <WaldenL@xxxxxxxxxxxxxxx>
wrote:

I wasn't look at it as being a positive if it was done in memory as

you are

:-) Joining result sets, IMO, should be done by the DBMS and not the
language.

Problem there is you make the assumption that the DBMS has access to all
the data. Actually, you make two assumptions, that's the first. The
second is that you want the DBMS doing it from a performance point of
view. Web servers scale out well, DBMS server only scale up well.

What if you're trying to sort the results of a webservice call? Or the
data in an XML table? Or even merging and then sorting the data from a
"join" between data in i, data in SQLServer and data from a webservice
call? In all these cases the DBMS alone doesn't have what it needs to
sort, because it doesn't have all the data. Now yes, you could then
write the "joined" row into a table in qtemp and then ask the dbms to
sort that table, but that seems like lots of extra work over just
letting the language/runtime sort it.

-Walden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.