Subscribe to the feed
Follow me on Twitter
Templating is a common technique for separation of concerns in applications - separating presentational logic from domain (or business) logic. This kind of separation promotes higher maintainability and a better chance to reuse presentational code (by encapsulating it in templates), the kind of traits we would all love to have in our code base.
Read the rest of this entry »
OO PHP templating
PHP • Web development November 18th, 2008Making web-pages go faster using PHP
Javascript • PHP • Web development November 16th, 2008UI responsiveness is one of the basics of a good user experience. In the web environment, this often translates to the loading time of pages.
As it might be expected, there are several techniques to optimize the delivery of web pages. The Exceptional Performance guide by Yahoo is a great resource for a multitude of optimizations practices, including specifically two techniques which I will address in this article - script minifcation and concatenation.
Read the rest of this entry »
Optimizing OR (union) operations in MySQL
MySQL • Open Source • Web development October 15th, 2008In my last post on database optimization, I focused on improving query performance by optimizing schema - exploring indexing strategies by reading the execution plan. In this post I'll show how different query structures can also have a major impact on performance.
Read the rest of this entry »
Profiling queries with Zend_Db and optimizing them by hand
MySQL • Open Source • PHP • Web development October 12th, 2008Database performance is one of the major bottlenecks for most web applications. Most web developers are not database experts (and I'm no exception), there are however several basic methods to analyze and optimize database performance without resorting to expert consultants (such as those, whose founders blogs are an invaluable source of MySQL knowledge).
Read the rest of this entry »
Octabox launched and I’m back to blogging
MySQL • PHP • Web development • techfounder October 10th, 2008I've been super-busy the last couple of months - I've came across a stupendous amount of work that I couldn't refuse in addition to the effort towards the release of my own startup, business platform Octabox. Things are finally calming down, and I'll be getting back to blogging, writing about plenty of things I've learned / implemented / experimented with the last two months.