Hello to all!
For some time now I have been working on a projector, more precisely, a module of one large projector. I use ActiveRecord. We have one table in the database, which is associated with several other tables, there are about 20-30 connections per record, as a result, when displaying 100 objects in the browser, about 500 requests are made to the database, respectively, the page loads from a second to three. This is not good, and fortunately, we were given time to finish and bring our projects to mind. Actually, I decided to fix the stagnation of my system, and start caching. For the sake of interest included caching in files, the speed of the system increased, users noticed it. Moreover, now only the objects themselves are cached, connections to them are not yet cached.
In general, I read on the Internet, gobbled the buzzword memcached, puzzled our administrator to put this miracle on a computer in Eveoperskuyu, and he began to learn how to do the correct caching of ActiveRecord objects in Yii. I hope for your help. Maybe there are some AR caching techniques? In general, for any links, or answers will be grateful)