Skip to content

Archive for

23
Jan

MySQL – optimize your query to be more scalable (Part 2/2)

databaseExperiment 3

The next experiment is to discover whether using the combination index can speed up the query. The following indices are created:

CREATE INDEX Id on T1 (Id);
CREATE INDEX Time_Id on T2 (Time, Id); Read more »

23
Jan

MySQL – optimize your query to be more scalable (Part 1/2)

databaseIntroduction

When we design and develop a database application, sometimes scalability is not considered or not a priority. When the size of data grows significantly, we often increase the hardware as the defacto solution. By understanding your MySQL queries, there may be easy steps to free up some processing power. In this article, I am going to discuss step by step, how to improve the performance of a simple MySQL query with a semi-large data set. The example shows a speedup from over 8 mins to just less than 30 secs.

Read more »

22
Jan

Windows Network Performance in File Shares – What lies beneath when you move your mouse

NetworkingWhen users experience a slow down in Windows File Share, often the usual suspect is the speed (bandwidth & high latency) or high volume of network traffic, but is it really? Read more »

22
Jan

Convert VCD movies to iPod with freeware

ipodI have lots of VCD movies in my shelf. It would be nice converting these movies onto my iPod and watch them while exercising in gym. After googling how to convert the VCDs into iPod, most of the solutions were referring to non freewares (I suspect most of the replies are by the authors of those tools).
However, I don’t believe that is the only solution. Some people post it by simply renaming the .dat file to .mpg file. That is not entirely true either although pretty close.
Read more »