Day 4: Basecamp Caching Considerations

Caching is taking far more resources than I expected. Overall I’m pulling ~ 3 megs of data for all people, companies, projects, and 30 days of time entries of a mid-size web development firm.

Since I’m taking advantage of ActiveRecord for relational object access, dynamic (on request) caching is going to be tricky. I’d have to hook into ActiveRecord’s primary key lookup mechanism and request the data from basecamp IFF we fail to find it in the DB.

I don’t think I will accomplish dynamic caching within this 7-day learning experience, but suggestions are welcome as always! =)

~ by philippp on June 19, 2007.