Month: October 2014

Assuming that table B is exact copy of table A, and that all necessary indexes are created, self-join of table A should be a bit faster than join of B with A simply because data from table A and its indexes can be reused from cache in order to perform self-join (this may also implicitly give more memory for self-join, and more rows will fit into working buffers).

If table B is not the same, then it is impossible to compare.

My online portfolio features some of the design works and projects that I have completed in the past. To navigate, click on the arrows or thumbnails. To pause the slideshow at any time, hover over the large image.

Personal Summary widget

Web development is a much, much deeper subject than simply building websites. It involves project management, agile work methods, and knowledge of a multitude of technologies, from the behind the scenes software that make websites come to life, to the ‘font end’ technologies that make the finished product look and feel welcoming for the user.

My passion for software development has lead me in to the the field of large scale, enterprise development projects, specialising in high quality, high capacity, and high availability software.
While I have traditionally been designing or building ‘back end’ projects, I have recently taken on a full spectrum project, involving everything from system adminstration to interfacing with external services, and cutting up the design in Photoshop. Versatility is important since the luxury of starting a project from the very beginning is not always possible.