Subject Firebird embedded questions
Author roar4711
Hi,

I got a couple of questions regarding Firebird Embedded 2.1.x

1. I'm not sure when reading the documentation what .conf paramters apply to the embedded version.

For example would any of these parameters be used by an embedded firebird ?

DefaultDbCachePages
SortMemBlockSize
SortMemUpperLimit
FileSystemCacheThreshold
FileSystemCacheSize

2. I am loading data from a table using IBPP and my own C++ app from the embedded 2.1.x database. IBPP has a single operation called fetch that fetches one row at the time.

Internally it looks something like this:

(*gds.Call()->m_dsql_fetch)(status.Self(), &mHandle, 1, mOutRow->Self());

I have no idea what the firebird interface looks like, but that 1 and the mOutRow gives some sort of hope that it would be possible to add a function to ibpp that fetched an array of records with one call ?

When profiling my application with VTune that call (not surprisingly since its called some 25k times) uses most of the cpu time.

Thanks in advance !