I am trying to implement disk based caching solution on top of ESE. Here the are requirements
- The cache (database) cannot grow more than a specified size.
- If the database size reaches 80% of specified size, older items must be deleted.
- Database must be online during removal of cache items.
Here are my questions
Are there any solutions that are built on top of Esent for this purpose?
Is there anyway to limit the database growth?
When I delete items from database, the size is unchanged. I did the defragmentation, but that still does not release the space. Is there a way to findout how much free space is claimed after defragmentation?
Is there a way to find out how much space is used by DB and how much space is left for writes with/without defragmenting?