memory pool stats

[pbour]

I create an environment with 32K cache.
The objective is to get the physical I/O accesses -basically cache
hits and misses.

I create my first database D1.
I pose a query on D1 and print the statistics. All OK till now.
I create my second database D2.
I pose again the same query on D1 and print the statistics. BUT now, only "Requested pages mapped into the process' address space" are larger than zero. Nothing on cache hits and nothing on cache misses.

OK, I 'll change the order. Meaning I create D2 and query it. All OK.
I create D2 and query it. PROBLEM zero stats apart from "Requested
pages mapped into the process' address space".

Before opening a database for querying, I create an environment DB_ENV
pointer with flags DB_CREATE|DB_INIT_MPOOL.

The code for creating and querying the databases is EXACTLY the same.

Any ideas why?


Thanx in advance.

[pbour]

I made a mistake on the process after changing the order. The
following is the correct one.

Post by pbour
OK, I 'll change the order. Meaning I create D2 and query it. All OK.
I create D1 and query it. PROBLEM zero stats apart from "Requested
pages mapped into the process' address space".