“Size does matter” – using cursor to sequentially process large database

Recently, I started working on a new project which uses postgres database and contains more than 3 million addresses. One of my first task was to geocode address. To do so, I wanted to sequentially access all the records ordered by address. As I never dealt with such a large database before, my first attempt was a [...]

Enhanced Caching of Views in CakePHP 1.2

Image borrowed from James Fee’s blog
It’s good to see that CakePHP developers worked on making Caching mechanism more effective and usable. In CakePHP, you can either 1) cache your data in controller or 2) cache your views (whole view or elements). Jiri talks in detail on how to cache data on controller side. So I won’t discuss that here.  Here I [...]