I would suggest to go with Ca Dir with the fact DB schema has limitation on # of characters it can store (especially on Artifact profile you will run into issues along with session persistence and SLO) even for high performance environments.Ca Engineering clearly mentioned about it to us and asked us move from a DB to Ca Dir which is free for session store