1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Rep Power

    HEAP type in Firebird?

    Hello, the application I'm writing uses a Firebird database, but needs to be blindingly fast. I've seen that, at least in MySQL, there exists a type called HEAP which stores the database in RAM. Does this also work in Firebird? Is there any other way to put the database in the memory, or otherwise speed up the querys??
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Transylvania (Romania)
    Rep Power


    On linux i can create a virtual partition in memory and use it in a normal way (create the database file , update ...)
    Here is the comand for linux for creating a 512M
    partition mounted in /mnt/memory_drive

    mount -t tmpfs -o size=512M,nr_inodes=10k,mode=0700 tmpfs /mnt/memory_drive

    I think there is a similar think for windows too

    Ps: The database in the memory partition is lost when you shut down the server/pc so you have to make copy/backup to a tape or hdd before
    Last edited by mariuz; January 21st, 2004 at 04:16 PM.

IMN logo majestic logo threadwatch logo seochat tools logo