January 21st, 2004, 02:42 PM
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??
January 21st, 2004, 04:08 PM
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.