Archive for January 9th, 2010

Optimizing SQL In Memory Table Scan processing speed (2010-1-9)

How fast can you can actually read data from a table that is already loaded in memory?  People often assume that, once it’s in memory, it’s as fast as it can get and won’t get any faster ? But how fast is it really ?  Let’s find out! The Math Method If the total table […]