[odb-users] Query caching in session

[Boris Kolpackov]

Hi Alessandro,

Alessandro Bellina <abellina at gmail.com> writes:

> The manual says that psql results are cached by default. Does this mean
> that the second query should be much faster?

You are confusing "query result caching" and "object caching". Query
result caching means that the returned data for the whole query is
transferred into the application's memory right away instead of
being streamed from the database server one-by-one (or by chunks),
when/if needed.


> Is there a way of knowing what the result cache looks like?

Well, it is the database state of all the objects (in some
database-specific binary form) as returned by the query,
excluding the state of the pointed-to-objects and containers.

Boris