When you come to the world of offline/disconnected application, you will hear the new buzzwords - AIR and Gear. Before I talked about these technologies, I want to talk about what problem we are trying to solve first. What we need an application to be able to function offline? First, Internet access is not everywhere. [...]

Continue reading " Adobe AIR vs Google Gear "

Below are some quick tips for MySQL tuning that I have learnt from my colleagues and books. To keep this article short and useful as quick reference, I will just put the common ones here.

key_buffer size. (for MyISAM - default at only 8MB)
innodb_buffer_pool_size (for InnoDB - default at only 8MB) - reference

You need buffer pool [...]

Continue reading " MySQL - Tuning Tips "

If you have a file of records, and you want to find out which record(s) meets the criteria like field1=xyz, field2=abc… How would you approach it? Simple! Load the file to database, write a sql with where clause and have the database taken care of it for you. Is it the simplest way? May not! [...]

Continue reading " Power of awk "