DelphiFAQ Home Search:
General :: Databases :: InterBase
Help with InterBase, Borland's open source database.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

InterBase, Exceptions and large databases

Problem:

An application that works against InterBase may work fine until the
database grows beyond a certain limit. Then the server fails with
an exception in "ibserver.exe".

Solution:

Consider this first:

  • check the db for validity (admin tool)
  • do a reindex. The problem may go away

    It could also be that your DB is simply too big. InterBase databases
    are limited to 4GB. To determine YOUR limit, multiply the number of
    database pages with the page size. You may have to set the page size
    to the possible max value of 8KB (during db creation).

    If your database gets bigger than the 4Gigs, then you have to use
    multiple files - InterBase allows huge databases by spanning multiple
    files and even multiple filesystems.

    For your existing DB, the statement "ALTER DATABASE" does the trick.

    Read file IB6.doc where it explains all about this.

  • Generated 12:00:33 on May 24, 2017