Re: DDM and SQL

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Well, you could use a test file and a comm trace to see what happens...

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Kirk Goins" <kirkg@pacinfosys.com>
Sent by: midrange-l-admin@midrange.com
10/09/2002 05:22 PM
Please respond to midrange-l


        To:     "Midrange-L (E-mail)" <midrange-l@midrange.com>
        cc:
        Fax to:
        Subject:        DDM and SQL


OK you database and DDM Gurus...

I'm not looking for a why or why not to do this, I'm looking for HOW it
does it..

Let's assume on a local machine I use SQL to select say 5,000 records from
say a 100,000 record file and assuming that the query optimizer uses a seq
read to get those 5,000 records... there is lots of I/O

Now Let's move the data to a remote system and use DDM. Does the machine
with the ACTUAL DATA do all the work and only return the 5,000 records
across the link or does EVERY Record get passed via DDM the source machine
which throws out the unwanted?



__________________________________________________
Kirk Goins
IBM Certified iSeries Technical Solutions Expert
IBM Certified Designing IBM e-Business Solutions
Pacific Information Systems - An IBM Premier Business Partner
503-674-2985           kirkg@pacinfosys.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.