Subject Re: [ib-support] Data Caching by IB
Author Kenneth Foo
I think Jack was referring to resultset caching,
a feature present in the newer MySQL.
Read somewhere about db benchmarks
where MySQL performance "rivalled" Oracle simply
because of this feature...


----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <>
Sent: Friday, August 23, 2002 11:01 PM
Subject: Re: [ib-support] Data Caching by IB

At 10:45 AM 23-08-02 -0400, you wrote:
>Does anyone know if Interbase supports data caching, wherein data once
>requested are placed in a cache for re-use in case the same data are
>requested again?
>I would like to know if (a) InterBase supports caching, and (b) if yes,
>whether caching can be defeated, and how.

You have multiply posted this same message in more than one list and have
received replies. Please check back through the archives.

Someone asked *why* you want to "defeat caching" and I'm curious too...

I'm wondering if what you really wanted to ask was "How can I defeat
asynchronous writes?" If yes, and you are on a Windows server platform,
the answer is YES, you can and should defeat it. Use the gfix
tool. Snippet from Using Firebird (applies also to InterBase):

Syntax for enabling and disabling Forced Writes
The command switch is -w[rite]{sync | async}
To enable Forced Writes:
gfix -w sync customer.gdb
To disable:
gfix -w async customer.gdb

It's particularly necessary to attend to this with InterBase, which creates
databases with Forced Writes disabled by default. It's not an issue on
Win9x or ME, which don't support async write at all. Firebird enables it
by default.


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to