RE: SQL Performance

["Allen, Stu" <sallen@xxxxxxxxxxxx>]

Try running the job in debug to see if the query optimiser is complaining
about something - are you using a logical file in your SQL statement, or a
physical?

Regards,
Stuart
                                                             
Stuart Allen
European Systems Analyst,  Fellowes
mailto:sallen@fellowes.com

> -----Original Message-----
> From: Contractor1@Parkdalemills.com [SMTP:Contractor1@Parkdalemills.com]
> Sent: Tuesday, August 01, 2000 2:21 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      SQL Performance
> 
> 
> We are using RUNSQLSTM to run a script that is chalked full of DELETE
> statements and it is taking forever. We noticed that the delete statement
> appears to be reading one record at a time and then deleting it. I say
> appears because that is what I am assuming looking at the open files when
> working with the job. The I/O count is double the relative record.
> 
> The files we are deleting have referential constraints. QQryDegree is set
> to *Optimize (now). Hmmmm, that's all. If you need more information, just
> ask.
> 
> So, any suggestions on how to speed this thing up? Write RPG program or
> what?
> 
> Patrick Conner
> www.ConnecTown.com
> (828) 244-0822
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> 
> 
----------------------------------------------------
Note:The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this message is
not the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and deleting it from
your computer. Thank you. Fellowes Manufacturing Company.
----------------------------------------------------
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---