Subject | [IBO] Re: Property Buffer Of TIB_Connection |
---|---|
Author | gigmbh |
Post date | 2002-01-14T21:39:38Z |
Hi Artur.
I've spent about two hours to find out whats going on with this
parameter.
I searched the whole web and also the usnet archive (google) to find
any discussion on this topic.
And still not it is not absolutely clear.
Here is what I found out by testing.
1.) Server is configured to have 2048 cache pages.
2.) Test-database has no setting for cache pages.
3.) Establishing a connection with isql without specifying the cache
parameter
4.) submitting a "SET STATS ON"; "COMMIT"; shows 2048 cache buffers
assigned.
5.) Quitting isql
6.) Starting a IBO application with no changes for Buffers property
(leave the default of 75 unchanged) and keep it connected.
7.) Starting isql again but with secifying the parameter cache 20
(You have to do this becuase if you would not specify the parameter
it would use the default of the server and because it is higher than
the buffers specified by the IBO app overwrite it.)
8.) submitting a "SET STATS ON"; "COMMIT"; shows 75 cache buffers
assigned.
What would be your conclusion ?
Give it a try in your environment.
Regards,
Frank.
I've spent about two hours to find out whats going on with this
parameter.
I searched the whole web and also the usnet archive (google) to find
any discussion on this topic.
And still not it is not absolutely clear.
Here is what I found out by testing.
1.) Server is configured to have 2048 cache pages.
2.) Test-database has no setting for cache pages.
3.) Establishing a connection with isql without specifying the cache
parameter
4.) submitting a "SET STATS ON"; "COMMIT"; shows 2048 cache buffers
assigned.
5.) Quitting isql
6.) Starting a IBO application with no changes for Buffers property
(leave the default of 75 unchanged) and keep it connected.
7.) Starting isql again but with secifying the parameter cache 20
(You have to do this becuase if you would not specify the parameter
it would use the default of the server and because it is higher than
the buffers specified by the IBO app overwrite it.)
8.) submitting a "SET STATS ON"; "COMMIT"; shows 75 cache buffers
assigned.
What would be your conclusion ?
Give it a try in your environment.
Regards,
Frank.