Re:

there is two reasons (maybe more) for using a stored procedure to do the
processing of the data.

1. Performance. As Bill said, returning only what you need. Consider
implementing as a Service Program. A lot quicker.
2. But the bigger reason is testing. You can test stored procedure
independently and make sure you are getting the correct data. This is huge.
You know you are getting correct data.

Everything formatted and all you have to do is present.




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

Thanks Mark for adding more information for him....

The trick to CR is to do as much as possible on the IBM i before it is
sent to the PC and the CR report showing the results.

Try to only send the records to the client/PC that the CR needs...

This is key to performance!

Let the IBM i do as much as it can...

Think about..

a + b = c for only customer = 123 on IBM i on a sale history file with 10
million records before it goes to client/PC and it only sends a 1000
records to the client/pc/CR or do it wrong and using just CR send 10
million records to client/PC before the a + b = c for only customer = 123
is done in CR.

Also Views stop the business from doing it to themselves...getting
different results because they do not know the files and the information
store in them or in some cases they just cannot add...

Thus the views as Mark stated...

Also
Do not allow full access with CR to your files on IBM i without thinking
about above!


Regards,
Bill Hopkins



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Murphy/STAR BASE
Consulting Inc.
Sent: Wednesday, May 22, 2013 5:56 PM
To: Midrange Systems Technical Discussion
Subject: Re:

Use an SQL view for best performance. But you can also use a logical file
by creating one that only includes the 5 fields of interest.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Crystal Reports <crystalcleardecisions@xxxxxxxxx> wrote: -----
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
From: Crystal Reports <crystalcleardecisions@xxxxxxxxx>
Date: 05/22/2013 12:43PM
Subject: (Untitled)

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.