Optimizing OR (union) operations in MySQL

MySQL Open Source Web development October 15th, 2008

In 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 more »


Profiling queries with Zend_Db and optimizing them by hand

MySQL Open Source PHP Web development Zend Framework October 12th, 2008

Database 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 more »


Octabox launched and I’m back to blogging

MySQL PHP techfounder Web development October 10th, 2008

I'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.

Read more »


Distiliing Usability

UI Web development September 23rd, 2008

Brilliant.

http://stuffthathappens.com/blog/2008/03/05/simplicity/


Chrome is out. Google has my vote

Open Source The Webs Web development September 4th, 2008

So Google Chrome was unleashed on the unsuspecting public yesterday with very little preceding hype. It enters a market that has thus far has had only two major players - Mozilla and Microsoft. Backed by marketing power that is unrivaled in the online world, it is strongly positioned to take both on (and especially Microsoft).

A web browser built on the webkit engine (same as Safari), Chrome offers a simple UI and extensive support for web technologies. Having used it for a couple of days now, it is striking to me how obvious it is that Google is a web company - in bold contrast to another software giant currently pushing for their next-gen browser.

Read more »


 Page 12 of 21  « First  ... « 10  11  12  13  14 » ...  Last »