this would have to depend on your odbc driver.
e.g. the visigenic driver was written before the time that IB introduced the
"get next n rows" feature, so the driver would have had to retrieve all
rows, then the asp page knows which one to start and stop on to create the
next 8 row page. When the next page is requested, again the whole resultset
is returned but this would must liely be in the cache (I mean the memory
page cache NOT resultset cache) and again the page would move next n rows,
start drawing and stop on n+8 rows again.
There may well be odbc drivers that can ask for the page only worth of rows
but I don't know of them.
In this case, though, no caching effet would be achieved at all since the
next page would come fresh from the server. If you went "back" you would be
again able to take advantage of the memory page cache.
Alan
-----Original Message-----
From: Jack Cane [mailto:jwcane@...]
Sent: Tuesday, 27 August 2002 0:01
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Data Caching by IB


Jason,

Thanks. Now, in order to be perfectly clear, let me pose an example. If I
ask for a Web page that sends back, for example, an html table based on a
data grid that is limited to 8 rows of data from a 500-row table, what
data
are cached, the 8 rows, or the entire table?

jwc
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Jason
Chapman (JAC2)
Sent: Sunday, August 25, 2002 6:41 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Data Caching by IB


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/

>
>
>

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]


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]