|Subject||Re: [Firebird-Java] Is there a way to specify size of cache and how much memory fb can use?|
> I didn't see anything mentioned in the manuals, but is there a way toSure, check the firebird.conf, the DefaultDbCachePages parameter.
> set the size of the db's cache?
You can override this setting on per database mode for Classic Server by
specifying the num_buffers connection parameter in JDBC (or was it
set_page_buffers?). For SuperServer the value is on per-server basis.
> Is there also a way to set the amountThat is the cache and TempCacheLimit parameters. Not sure if that can be
> of main memory firebird uses?
overriden via JDBC connection parameters.
> I've been setting the JVM's max heapIf you run Firebird as a server, Java heap won't be used anyway - those
> memory size, but it won't prevent firebird from trying to use more
> than that.
are two different processes. In the embedded mode that does not work
either, since fbembed.dll/.so also use different memory managers. So you
only friend is the firebird.conf