Quote:
Originally posted by m4tt
With a traffic trading script, I highly doubt that flat file is faster than mysql. Someone prove me wrong.
|
Sure. The first version of arrow trader used mysql as it's main database system instead of flatfiles.
During a speedtest, I loaded about 25 urls from a mysql database, and some rows with numbers.
Running this 2500 times, took 2.406 seconds.
That are 89,775,561 (89 million) queries per day.
In the second part of the speedtest, I loaded the exact same data from a flatfile.
Running this 2500 times, took 0.020 seconds.
That are 10.800.000.000 (10.8 billion) queries per day.
Quite a difference not?