Question BUFFER copy VS dump, load, and index rebuild

[dbacdog]

OE 11.7.6
SOURE OS : HP-UX
TARGET OS RHEL

I will test this soon, however wanted to get others opinion.

First i'm going to delete around 300 millions records from source.
Should I do a ;
1. BUFFER copy to target database (to empty database) or Dump, Load, and of course index rebuild.to target?

Thanks in advance!

 

[TomBascom]

How does either approach accomplish the deletion of 300M records?

At one time, with certain (very old) Progress versions and poor disk hardware you could make a case that using 4GL programs and BUFFER-COPY could be faster than a binary dump and load because you can eliminate a lot of intermediate IO. Personally I have not found that to be true anytime in the last 10 years. These days binary D&L is the hands down winner.