View Single Post
Old 08-05-2003, 01:38 PM  
hvidlogspusher
Confirmed User
 
Join Date: Jul 2003
Posts: 315
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?
either you are lying or the mysql config on your sux more then the default config
hvidlogspusher is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote