MSSQL latest versions have a feature to cache "results" and re-uses them if
it can, e.g. multiple users posting the same SQL.

IB / FB does not cache results ever. It does however cache the raw data
that was used to generate the results, i.e. data pages from disk. The
obviously cache's disk reads also.

I don't think you should change IB/FB's cache settings as this may adversely
affect normal operation.

When we do testing we have a ground zero state, it may be a fresh boot of
the OS, it may be a a restart of the FB service, depends on what we are
doing.

Jason Chapman
JAC2 Consultancy

Training - Development - Consultancy
Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....
www: When I get round to it....
Mob: (+44) 07966 211 959 (preferred)
Tel: (+44) 01928 751088



""Jack Cane"" <jwcane@...> wrote in message
news:NBBBJIAMCLJIMAIEKAKEOECKFNAA.jwcane@......

> Yes, exactly. result set caching is what I meant.
>
> So, now it appears to me that IB does not do resultset caching. Is that
> correct?
>
> jwc
> -----Original Message-----
> From: Kenneth Foo [mailto:kenneth@...]
> Sent: Friday, August 23, 2002 10:18 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Data Caching by IB
>
>
> 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...
>
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

>
>
>
>
> 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]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>