Events Calendar Performance

Many complaints about sluggish events calendar performance. After considerable analysis, the bottleneck was . Talks with SAA suggested Network File System (NFS) performance as culprit, as was how the CodeIgnitor MVC (model-view-controller) framework used the file system.


Case in point: I had a CodeIgnitor “View” (a single php file) that displayed details of one event. The default calendar view displays maybe 70 events, past and present. So, application loops through all the events, invoking the Single Event View 70 times. That incurred 70 file reads from a sluggish NFS file share. SSllllloooowww.

So I recast the 1-event-view as a function call. 1-event view loads function once, invokes function once. N-event-view loads function once, invokes function N times. Fast.

While I was at it, I optimized some of the SQL queries by adding additional indexes to database tables.

About Wesley Wright

Born on a mountain top near New York City, Craziest state in the land of the pretty. Raised in the woods so's he knew every tree, Killed him a bear when he was only three.
This entry was posted in Wes and tagged , , , , . Bookmark the permalink.