Thanks for your reply Jason.

I ended up using the TIBRestoreService component that comes with
Delphi. When our app does a backup and restore it allows the buffers to
be modified. I agree with your comments regarding DB management.
However by and large our user base will use the defaults and by allowing
our app to change this simply allows the users an easy way to make a
change based on advice.



Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Jason Wharton wrote:

>Yes, it is possible by messing around with the DPB (database parameter
>buffers) when connecting via the API. That is what the gfix tool does. I
>don't specifically recall exactly where I made these available via
>TIB_Connection but for sure there is an event to customize them and plug
>them into the buffer sent to the API when calling the connect API call.
>
>I want to say, however, that I discourage this. I believe it is best to
>separate administration functions from application functions. If you embed
>it in your application EXE then if you make an administrative change you
>will have to re-deploy a new application or in some way be dependant upon
>your application to mess with this.
>
>Jason Wharton
>www.ibobjects.com
>
>
>
>
>>-----Original Message-----
>>From: Robert martin [mailto:rob@...]
>>Sent: Monday, March 28, 2005 4:52 PM
>>To: IBObjects@yahoogroups.com
>>Subject: [IBO] Firebird Buffer size
>>
>>
>>
>>Hi
>>
>>Is it possible, with the IBObjects components, to set the #
>>of buffers
>>similar to the gfix command (gfix -buffers n Database_name)?
>>We would
>>like our application to control the database cache size.
>>
>>
>>--
>>Rob Martin
>>Software Engineer
>>
>>phone +64 03 377 0495
>>fax +64 03 377 0496
>>web www.chreos.com
>>
>>Wild Software Ltd
>>
>>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>

[Non-text portions of this message have been removed]