15 October
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 …
12 October
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 …
4 September
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 …
18 July
Handling mail is a very common requirement in web applications. Even the most basic sites usually have a contact form that sends a mail through the server instead of putting a contact mail address for spam-spiders to find. Using PHP’s built in function (aptly named mail() ) is relatively straightforward - until you need slightly more advanced features, such as adding and encoding email headers or sending multiple mails efficiently.
Read more …
1 July
Content syndication or Feeds, is a mashup of technologies that provides an easy way to keep track of updates from multiple content sources. Despite being very useful, it has yet to find widespread acceptance amongst Internet users.
Direct usage statistics are hard to ascertain with great precision, but they revolve around 4%-6% of the total Internet population, which is not much. More feeds are being consumed indirectly by aggregation sites, such as my yahoo and iGoogle (as this Yahoo! paper shows), which shows that there is market ready to consume more feeds.
So why feed usage isn’t more widespread? Read more …