[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Dump, Load and Index Rebuild on Type II Database. - Performance

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
Text dump with TABLE-SCAN option or binary dump with the index 0 will be faster. Or check the quality of the indexes and use the one with the minimal logical scatter factor (or the one with smallest size). You can use my SeekRatio.p program: ftp.progress-tech.ru/.../SeekRatio.p By default the program reads only first 10,000 records using each index.

Continue reading...
 
Status
Not open for further replies.
Back
Top