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

jwc


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


Jack,

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
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"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

with

> 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

make

> repeated tests, and would like to avoid the effects of database caching.

The

> WebApp and database server are running on a Windows platform (Win2k

Server).

> 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
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]