-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: Friday, August 23, 2002 6:16 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Data Caching by IB


At 23/08/2002 06:57 PM, you wrote:

>Martijn,
>
>My immediate goal is to test web application performance, not to improve

it.

>To give a valid test result requires absolutely consistent performance of
>data retrieval functions. From the answers I have received so far, it
>appears that the best way to achieve this is to avoid caching. For

updates

>and insertions, I would propose to use gfix to enable forced writes. Is

it

>possible to prevent caching of read-only data?

Not that I know of.

[Jack Cane] Is it possible to clear the cache? Is there an API call that
is accessible via Delphi?

My idea is this: In making multiple calls for a set of n rows of data,
arrange to shift the database cursor by n for each successive call. Thus,
new data are always requested, and cached data are never requested again
during the current test. When repeating the test it will be important to
clear the cache memory first. Is there a way to do this without stopping and
restarting Firebird or Interbase?

jwc

> Maybe I have to set
>#DATABASE_CACHE_PAGES to 0?

Don't forget to use gfix to modify at the database level as well. What
I've found is that the one in ibconfig is the default value that is used
when creating a database. Then to change that value, you have to use
gfix. But, setting both of them to 0, should do the trick. And, don't
forget to restart the server, so the changes in ibconfig come into effect.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)



Yahoo! Groups Sponsor
ADVERTISEMENT



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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