DelphiFAQ Home Search:

InterBase, Exceptions and large databases

 

commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

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.

    Comments:

    2012-11-12, 03:53:19
    anonymous from United States  
    2015-01-30, 00:17:36
    anonymous from Venezuela  
    Don't forget in order to see the label rropet in its full glory that you use the print preview mode and not the other views as they will only show one column no matter how many columns you had chosen for your label rropet.

     

     

    NEW: Optional: Register   Login
    Email address (not necessary):

    Rate as
    Hide my email when showing my comment.
    Please notify me once a day about new comments on this topic.
    Please provide a valid email address if you select this option, or post under a registered account.
     

    Show city and country
    Show country only
    Hide my location
    You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
    Please type in the code:

    Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
    The owner of this web site reserves the right to delete such material.

    photo Add a picture: