Re: SQR Performance Issues (New Question)

["Love, Kristin" <KLove@MSA.COM>]

Get a copy of Oracle SQL High Performance Tuning by Guy Harrison.

It explains what makes SQL statemenst slow or fast.

If you're not using ORACLE, the concepts still apply to some extent, or else
you can seek out an equivalent book of your flavor.

> -----Original Message-----
> From: Sarah Jane A. Lohrey [SMTP:lohreysj@MUOHIO.EDU]
> Sent: Friday, March 09, 2001 3:40 PM
> To:   SQR-USERS@list.iex.net
> Subject:      SQR Performance Issues (New Question)
>
> Hello Everyone,
>
> I was watching all of your postings with regard to Deepak's questions on
> SQR Performance Issues and I have a new question for you.
>
>
> I consider myself a novice at SQR yet I have been asked to give a 3 hour
> workshop to discuss performance issues in SQR programming to a small group
> of users who are even newer to SQR than I am.   I'm hoping some of you can
> add to my list of "Performance issues" to consider.
>
>
> The kinds of things I have been think of so far include:  (NOTE:  THERE
> ARE
> SOME QUESTIONS IN MY LIST)
>
> 1. From our most recent postings about using count(*) in subqueries.
> There
> are more efficient ways to write subqueries.
> 2. When using evaluate statements, one should use break logic and evaluate
> the values that are most frequent first so that the break logic will exit
> an evaluate sooner.
> 3.  When performing selects to multiple tables, does the order of the
> fields in the select affect performance?  Perhaps the order of the tables
> in the from clause or the where clauses affect the performance.   Do you
> want the smaller tables listed first or last?
> 4. Is it true that the LET command is less efficient than the MORE
> command.
> 5.  ....
>
> What are some of the most common consideration you have when attempting to
> develop efficient programs?
>
>
> Thanks in advance for any thoughts you might have on this subject.
>
> Sarah
>
>
>
> Sarah Jane A. Lohrey
> Programmer
> Miami Computing & Information Services
> PH: 513.529.6074
> FX: 513.529.1434
> lohreysj@muohio.edu