Subject Re: [ib-support] Data Caching by IB
Author Martijn Tonies

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 would
> have replied there, but did not think it was appropriate.
> I am testing the performance of a dynamic data-serving Web application by
> 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.