Daniel Magin’s Weblog

My life in the Developers World

InterBase XE Pages are online now!!!

for some minutes Embarcadero has published the new web pages from InterBase XE the new version incl. 64bit, FastSweep, Execute Statement in Stored Procedures and much much more.

Visit the new InterBase XE Pages


daniel (magin)

Think IB!


September 21, 2010 - Posted by | Embarcadero (CodeGear) stuff


  1. Where can I find more about the FastSweep?
    After some manual search I found one line about native 64bit. I would like to read more about technical internal changes.

    Comment by André | September 21, 2010 | Reply

    • Database Fast Sweep
      Sweeping a database is a systematic way of removing outdated records. Periodic sweeping prevents a database from growing too large. In the past sweeping slowed system performance and users disabled the automatic database sweep function because of the impact on product operations.

      InterBase databases periodically need to be swept. Otherwise the main memory allocated for each transaction’s bitmap increases to the point where performance becomes unacceptable. The longer sweep takes to complete, the more main memory requirements increase for starting new transactions.

      With the implementation of the fast sweep optimization in InterBase XE, the memory allocation issue has been mitigated. The user has the option to configure their databases for automatic sweep. In cases where large databases have large archival or infrequently modified tables, a database sweep will have minimal impact on the performance of running transactional operations.

      User Interface/Usability

      There is no new user interface or action required by the user to enable this functionality. Manual sweep initiated by the GFIX command line tool, IBConsole, or programmatically, as well as automatic sweep configuration on a database, use the fast sweep mechanism.

      Requirements and Constraints

      Only ODS 15 and later databases can perform fast database sweeps.

      The effectiveness of a fast sweep is directly proportional to the fraction of database data pages that have been modified since the last sweep. If every data page has been changed, fast sweep is no faster than the former methodology. If very few pages are changed, fast sweep is nearly instantaneous. If half the pages were updated, fast sweep is then half the former sweep time.
      Migration Issues

      A database needs to be created or backed up and then restored to ODS15.

      Comment by dmagin | September 22, 2010 | Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: