Subject RE: [ib-support] Data Caching by IB
Author Jack Cane

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? Maybe I have to set


-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Friday, August 23, 2002 4:17 PM
Subject: Re: [ib-support] Data Caching by IB


If a performance boost is what you want, have you thought of a middle
tier yet that responds to data changes (events?) and the webpages get
their data from the middle tier that has a cache of data? This improves
performance A LOT. I've created such an application once when the
expected hit-rate for a webpage was about 70 hits/second and the new
entries about 40/second. The read-only views had to present ordered
data from a couple of tables including tables with over 200.000.000 rows.
Ordering such an amount of data is pretty hard on the database server -
and I had to order all rows :( ... eventually, we decided on a caching
middle tier - whenever new data was added, it was checked if it fit in
the cache (about 100-150 rows), if so, it was inserted into the ordered
list from the cache. The read-only views would come directly from the
cache... Worked great.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."

> A response to my inquiry on the other list (I only saw one reply) began
> the admonition that I was posting that inquiry on the wrong list. I
> have replied there, but did not think it was appropriate.
> I am testing the performance of a dynamic data-serving Web application
> making queries of a data source connected to the application. I need to
> repeated tests, and would like to avoid the effects of database caching.
> WebApp and database server are running on a Windows platform (Win2k
> I'm using Firebird. I thought Firebird and Interbase were equivalent.
> Apparently the implementations differ as to some settings such as Forced
> Writes on/off.

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

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

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