Issue Details (XML | Word | Printable)

Key: CORE-4170
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: kdv
Votes: 1
Watchers: 1

If you were logged in you would be able to see more operations.
Firebird Core

Allow (add) ability to specify database cache in kb/mb/gb

Created: 06/Aug/13 08:22 PM   Updated: 22/Nov/13 07:24 AM
Component/s: Engine
Affects Version/s: 3.0 Alpha 1
Fix Version/s: None

 Description  « Hide
I ask in addition to existing DefaultDbCachePages add new firebird.conf/database.conf parameter
DefaultDBCacheSize which can be specified in kilobytes, megabytes or gigabytes of memory directly.

For example,
DefaultDBCacheSize = 8m
i.e allocate 8 megabytes of cache for the DB.

Of course, engine can divide this value by page_size and select closest round number of pages for cache.

If both DefaultDbCachePages and DefaultDBCacheSize specified, bigger value can be taken.

As alternative to gfix -buffers n, I think, need to be added new parameter. maybe -cachesize n ?
Also we need new dpb parameter like isc_dpb_num_buffers.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
kdv added a comment - 07/Aug/13 08:07 AM
btw, by new gfix -cachesize n option I mean that it need to be stored in addition to -buffers, not computed and transformed to the "page buffers" value in header page.

Alexander Peshkov added a comment - 22/Nov/13 07:24 AM
Dmitry, why do you think it's better to have two mutually exclusive values instead one, calculated when other format is used?