|
Oct 10
|
Today I've learned the easiest way to load MySQL data onto RAM. I needed it for my testing purpose and it works fantastically well. I wanted to test the speed of fetching 100,000 data in 26 times. The first time I did, without loading the data onto the ram, it runs around 35 mins for 100,000 resulting in approx 66 queries per second.
After I load the data onto the RAM, it runs at the rate of 8000 queries per second. Tremendous improvement. So how do I do it?
Thank to my friend, I've learnt how to do it. I just need to do a SELECT from the table that contains the 100,000 data, before I run the test codes. It's that simple 
