| Subject | RE: [ib-support] Data Caching by IB |
|---|---|
| Author | Jack Cane |
| Post date | 2002-08-26T23:31:06Z |
Can you explain the difference between memory cache and result set cache?
If I understand Helen Borrie correctly, this caching is only useable by the
current transaction and would not be applicable to another user who comes to
the server asking for the same data.
tks,
jwc
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Monday, August 26, 2002 5:42 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Data Caching by IB
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@......
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]
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]
If I understand Helen Borrie correctly, this caching is only useable by the
current transaction and would not be applicable to another user who comes to
the server asking for the same data.
tks,
jwc
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Monday, August 26, 2002 5:42 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Data Caching by IB
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.that
>
> So, now it appears to me that IB does not do resultset caching. Is
> correct?http://docs.yahoo.com/info/terms/
>
> 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
>Service.
>
>
>
> 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
>http://docs.yahoo.com/info/terms/
>
>
> [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
>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]
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]