Re: SQL Delete Performance - Why so Horrible?

[DGray@xxxxxxxxxxxxxxx]

Did the index help speed it up?
Also, is the file journaled or have triggers or constraints on it -  and
how is your RPG-SQL program compiled (with or without commitment control)?

-Daniel


Phone: 501-955-1221
Fax: 501-955-4221


                                                                           
             William                                                       
             Washington III                                                
             <w.washington3@sb                                          To 
             cglobal.net>              midrange-l@xxxxxxxxxxxx             
             Sent by:                                                   cc 
             midrange-l-bounce                                             
             s@xxxxxxxxxxxx                                        Subject 
                                       Re: SQL Delete Performance - Why so 
                                       Horrible?                           
             04/14/2005 04:28                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




Thanks for all who responded so far...

More info:

The file has no indexes.  (I just added one by company to test some things
out.)

The file will delete a high percentage of records (from 50% to 100%, based
on
the number of companies currently being processed.)  I can only delete the
records of the company being processed, so that eliminates DROPping and
reCREATEing the file.

Will a non-unique index help with this high of a delete percentage?

Is there a way to "turn off" the overhead for this file, because I really
use
it as a work file (but I must keep it until I run the process again.)

... a tricky thing, this SQL stuff...

William