[progress Communities] [progress Openedge Abl] Forum Post: Re: Database Really Slooooow

  • Thread starter Thread starter cjbrandt
  • Start date Start date
Status
Not open for further replies.
C

cjbrandt

Guest
Because of Type I storage areas and the few records read / db read, the database tables probably have high scatter factor and fragmentation. Since the db is 32 bit, you can't allocate a large number of buffers to help that issue. A full D&L if you have time. Another option would be to create a new Storage Area for the smaller tables with high read rates. Then move those tables to the new Storage Area.

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