Eviction in Partitioned Tables

In partitioned tables, SQLFire removes the oldest entry it can find in the bucket where the new entry operation is being performed. SQLFire maintains LRU entry information on a bucket-by-bucket basis, because the performance cost of maintaining information across the entire partitioned table is too great.

SQLFire chooses buckets for LRU eviction in these ways:

Eviction in a partitioned table may leave older entries for the table in other buckets in the local data store as well as in other hosts in the distributed system. It may also leave entries in a primary copy that it evicts from a secondary copy or vice-versa. However, SQLFire synchronizes the redundant copies when an entry with the same primary key is inserted or updated.