ActiveRecord Session Store

I just recently moved from Cookie session store to ActiveRecord session store and I saaw my average page response time go from 300-500ms go to 800-1100ms. Would ActiveRecord session store be the cause of such a difference? I figured I would maybe take a 40-50ms hit at the most. Does that make sense?

John Kopanas wrote:

I just recently moved from Cookie session store to ActiveRecord session store and I saaw my average page response time go from 300-500ms go to 800-1100ms. Would ActiveRecord session store be the cause of such a difference? I figured I would maybe take a 40-50ms hit at the most. Does that make sense?

I'm with you on the performance thing. The AR store should be slower but not by that much. How many sessions are in the table? Are the indices correct? Which database management system are you using and which Ruby driver?