Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PrimaryIndex count

user13726488Apr 2 2014 — edited Apr 3 2014

I have a doubt about cache.

The Environment is transactional and the configuration is the default options.

I have Primary Index like that:

private PrimaryIndex<Long, EnSomeEntity> pkSomeEntityById;

I did record on it about 100000000 (one hundred million) elements.

A huge amount of data about 80G of data.

1- I did a count on it it returned the one hundred million elements count but id delayed about 15 minutes.

How I did:

pkSomeEntity.count();

2- I did the count again and it returned in 8 seconds.

3- I did restart the machine; now I did the count on it it delayed about 15 minutes again.

4- I did the sarch again (after restarting) the count returned in 8 seconds.

This cache is handled by the Berkeley DB or it is the Disk Cache. (the disk is not SDD, it's a 'normal' SATA).

What's the best way to handle cache with this huge amount of data?

This post has been answered by Greybird-Oracle on Apr 3 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 1 2014
Added on Apr 2 2014
1 comment
1,051 views