Posted by admin on April 16, 2008
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. [...]
Posted by admin on April 5, 2008
Understand Query Processing Basic Before tuning your slow query, you better understand how your database process your query first. Here are the steps: Each client connections gets its own thread within the server process (MySQL). The connetion’s queries execute within that single thread, which in turn resides on one core or CPU. The database server [...]
Posted by admin on April 4, 2008
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! [...]