How to configure a Firebird Database to run in memory

views:

358

answers:

+1 Q:

How to configure a Firebird Database to run in memory

I'm running a software called Fishbowl inventory and it is running on a firebird database (Windows server 2003) at this time the fishbowl software is running extremely slow when more then one user accesses the software. I'm thinking I maybe able to speed up the application by forcing the database to run "In Memory". However I can not find documentation on how to do this. Any help would be greatly appreciated.

Thank you in advance. Robert

+3 A:

Firebird does not have memory tables - they may or may not be added in future versions (>3) but certainly not in the upcoming 2.5. There can be any other number of reasons why your software is slow with multiple users; however, Firebird itself has pretty good concurrency, so make sure you find the actual bottleneck first.

Holger Hoffstätte 2010-02-01 21:52:49

The "in memory" was within quotes, so I assume Robert want's to be able to page as much of the database in memory as possible. This can be done by setting some properties in the firebird.conf file. Look at DefaultDbCachePages, but the file is pretty self explanantory.

Ritsaert Hornstra 2010-02-02 12:27:10

+1 to Holger. Find the bottleneck first.
Sinática Monitor may help you.

Douglas Tosi 2010-02-02 11:58:20

* Which version of firebird ? – 2.1.3.*Which middleware you use to connect Firebird ? Java.*Good question, along with near-dupe stackoverflow.com/questions/2180616/…, but belongs on serverfault.com – I will place it there as well.

Robert 2010-02-03 14:09:49

*Make sure you find the actual bottleneck first - great point, , I have been working to find it. I will look at sinatica, Any other tips?*The "in memory" was within quotes, so I assume Robert want's to be able to page as much of the database in memory as possible. This can be done by setting some properties in the firebird.conf file. Look at DefaultDbCachePages, but the file is pretty self explanantory. – I will do that thank.

Robert 2010-02-03 14:10:16

I have read an article some time ago, from someone who did a memory drive (like in old DOS) and ran a Database there. Te problem is if anything fails. You loose everything. You should do backups very often to ensure a minumum of security. Not a good idea at all I think.

Duilio Juan Isola 2010-05-22 19:13:38

ansaurus

tags:

views:

answers:

How to configure a Firebird Database to run in memory

related questions