RE: SQL Performance

[Contractor1@xxxxxxxxxxxxxxxxx]

I will try debug and it is physical files.

Patrick Conner
www.ConnecTown.com
(828) 244-0822



                                                                                
                 
                    "Allen, Stu"                                                
                 
                    <sallen@fellowes.co        To:     
"'MIDRANGE-L@midrange.com'"               
                    m>                         <MIDRANGE-L@midrange.com>        
                 
                    Sent by:                   cc:                              
                 
                    owner-midrange-l@mi        Subject:     RE: SQL Performance 
                 
                    drange.com                                                  
                 
                                                                                
                 
                                                                                
                 
                    08/01/00 09:49 AM                                           
                 
                    Please respond to                                           
                 
                    MIDRANGE-L                                                  
                 
                                                                                
                 
                                                                                
                 



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
>
> 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?



+---
| 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
+---