Quote:
Originally posted by Spud
so how's the load on MySQL? I find the ttt puts a big strain on it
|
It's also almost completely MySQL driven.
If you want some performance stats...
My test box is a PII at 350MHz, 326 MB RAM running Apache 1.3.27 with PHP 4.3.0 and MySQL 3.23.51 with cache optimizations. All custom compilled, including the linux distro.
I hammered it with fake traffic (hitboted the test box). The traffic was :
in traffic - 259200 (3 in requests per sec)
out traffic - 432000 (5 emulated clicks per sec)
The box dealt with that during 24 hours with no problem.
If you are concerned about the MYSQL queries speeds... On the same box the main SQL queries in raw take:
ip, geotargeting, filtering: 0.03 sec
other queries: about 0.05 sec
trading algorythms calculations: 0.02 sec
As you can see, it's quite fast if you have a good server config. Also if your server is a fast box (remember that my test server is an old 350 MHz box) it will not give you any problem even with high traffic.
Quote:
Originally posted by Rui
any limitations you should make people aware of?
btw keep the working coming ;)
|
No limiations as I know, the only limitation is to the hitboters and cheaters, they will have it very hard to cheat this script.
The first time I installed the final version and set it up and running on my site the filter blacklisted my IP because I was reloading my main page too much times
