Mega Code Archive

 

Categories / Delphi / Examples

 

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.