Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2327
  • Last Modified:

Database sweep

what does database sweep actually do
0
jobarb
Asked:
jobarb
1 Solution
 
idtCommented:
A sweep performs garbage collection on the database.

As records are deleted, or updated, the old version of the row remains in place, simply marked obsolete.  Over time your database is a mixture of current versions and backversions of rows.  Depending on the activity of your database, that is how often rows are deleted or updated, a considerable amount of the total diskspace is occupied by these back versions.

When a sweep is performed, the database pages are examined to see if the page can be marked free, that is used by new data.  This can improve performance since if no free pages are available, additional disk space needs to be allocated from the OS.

Additional performance is gained since these pages are no longer read when performing natural scans, and index traversing.

You have a choice of allowing sweep to run automatically every N transactions, or manually.

Daniel
0
 
BAlexandrovCommented:
Here one very good article about Interbase specifics
http://bdn.borland.com/article/0,1410,23216,00.html
0
 
Earl_KaplanCommented:
Mainframe dinosaurs will remember that the sweep process is called database reorganization (reorg) and was done regularly.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now