MangoOrange™

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

written by mangoorange \\ tags: cache, memory, mysql

A cool solution I found at removing duplicates in a table here. Instruction is quite clear.

http://free.netartmedia.net/Databases/Databases8.html

written by mangoorange \\ tags: mysql, remove duplicates