Subject Re: [IBO] Re: Property Buffer Of TIB_Connection
Author Artur Anjos
This make me think twice about it.

The parameter should be only one byte, so 255 is the maximum value. It's ok. So, this will be the cache used for each connection, not the database_cache _pages defined at the server. I think the confusion that starts here because of the default value of this parameter on the server, that it's also 75.

I'm a little bit confuse about this. Does someone explain this parameter to me better? Maybe we should go to the ib-support for discussing this?

I already checked the IB Manual and I'm quite shure that the length for this parameter should 1, so 255 it's the limit. The server will increase the buffers only if this value will be higher. But, we can use a higher value on IBCONFIG file on the server.

I think this is related with the cache used by each connection, not the DATABASE_CACHE_PAGES defined in the server. In my opinion, this is something related with the cache that the server keeps for working with the conection. So, it makes sense to keep that value in the client side.

Am I wrong?


----- Original Message -----
From: Jason Wharton
Sent: Monday, January 14, 2002 5:17 PM
Subject: Re: [IBO] Re: Property Buffer Of TIB_Connection


That sounds acceptable to me. Feel free to make the simple changes and email
me privately the changed file so I can merge it into the sources?

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "gigmbh" <ZJQBBYSESPEZ@...>
To: <>
Sent: Monday, January 14, 2002 9:48 AM
Subject: [IBO] Re: Property Buffer Of TIB_Connection

> > IBO should not override it if you have it at its default
> > setting. I probably need to look into the code and see what is
> > going on. There could be an issue in there.
> I have already done that.
> Take a look at line 1174 in IBA_COnnection.IMP.
> if FConnectedSQLRoleName <> '' then
> BuildDPB( bufptr, buffer, isc_dpb_sql_role_name,
> FConnectedSQLRoleName );
> BuildDPB( bufptr, buffer, isc_dpb_num_buffers, Chr( Buffers ));
> There is no condition for building isc_dpb_num_buffers DPB.
> As 0 (zero) is no valid parameter, how about using it to
> specify "use the default" ??
> Regards,
> Frank.

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