Quote:
Originally posted by Aheib
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?
|
Well I can't see any site needing 89million hits worth, so really what your test shows is either will work just fine and if tuned properly you could speed up the mysql version.