Re: Re:

Yes they can...consider how much data you'er reading and sending just to
throw away.

If you defined a view and where using SQL, you could even have a matching
index with all three fields and the system could use "index only access" to
return data even faster.

Charles


On Wed, May 22, 2013 at 4:43 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

Good so in the Logical i have it seems that the logical returns all of the
fields of the Physical, lets say 100 fields. WHen we may be using only 3
fields in the Crystal. Are these extra 97 fields going to cause a slower
performance or its not an issue as number of records are.


On Wed, May 22, 2013 at 4:09 PM, Bill Hopkins <bhopkins@xxxxxxxx> wrote:

In the past I would create a Stored Procedures on the IBM I using either
SQL or RPG to select and generate only the records I wanted on the CR.

This

greatly improves performance of CR since all the selection and number
crunching is done on the IBM i and not on the local PC by CR.


Regards,
Bill Hopkins



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John McKee
Sent: Wednesday, May 22, 2013 2:39 PM
To: Midrange Systems Technical Discussion
Subject: Re:

The few times I have used CR to access data on the i, it was done using

the

PF in a subreport. All the PF fields were available. I would assume

that

a LF would only return the records it referenced and then only the fields
that were defined in the LF DDS.

John McKee


On Wed, May 22, 2013 at 11:43 AM, Crystal Reports <
crystalcleardecisions@xxxxxxxxx> wrote:

It seems to me, if I remember, the logical file, when used in Crystal
REports, it passing not only all the records of the file OEOEHDOH, but

also

all the many fields. Is this correct?
If the CR only is interested in say 5 fields, how can we code this

logical

or to make a new one that will only pass less, is that a performance

issue

would you say?
I have also added a temporary filter to this logical
R OEORHDRR PFILE(OEORHDOH)
K OHORDT R K OHSHTC R
K OHORDD R DESCEND
O OHORDD COMP(LT 20130101) *** MY ADD O
OHSHTC COMP(EQ ' ')
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

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