G
George Potemkin
Guest
> Table Create Update Delete > A 326K 12.2M! 465K More deletes than updates?! The number of records in the table is decreasing. Not to zero? ;-) > B 335K 417K 333K > C 176K 196K 177K It might be that the most updates happen right after the creates. For example: do transaction: create table. assign table.key_fields. assign table.other_fields. end. If this guess is correct then you need carefully to choose RPB for these two tables (or to set the create limit if this option is available in your Progress version). > I can't see 'RM chain' in the dbanalys output. Should I be running something else? Did you run dbanalys or tabanalys?
Continue reading...
Continue reading...