RE: [coldbox:4888] performance on large caches

I can understand not wanting extra inserts or updates on your DB, but reads shouldn’t be too bad. Put a covered index on the primary key and your hash column, and pull it out with a nolock and the over head should be an index scan with nothing but a schema stability lock. I would say the disk read activity would be well worth not having to recalculate the hashes after every CF server restart.

~Brad