Performance

[GoogleCodeExporter]

Hi guys:
I'm using Allstats for several months, each day there will be 100-200 games
hosted by my Ghost++ bot, now I've about 20,000 games in the database (the
gameplayers & dotaplays' tables have 200,000 records).

When we do the top plays query (joined several tables), it will timeout.
Will you consider the performance of some queries in the future versions?
Thanks for your amazing work :)

Original issue reported on code.google.com by zwd2...@gmail.com on 19 Jan 2010 at 6:48

[GoogleCodeExporter]

Hi,

I have about 12,000 games so have created new database for 2010 year. Now I have
archived database for 2009 year. It will be better to add support for archiving
records (3 months, 6 months, 1 year etc.) and reduce database queries (for 
example:
one database with different category for archiving - months, years...)

Original comment by ivan.anta@gmail.com on 21 Jan 2010 at 3:46

[GoogleCodeExporter]

Agree, this is very pity. I have not strong VDS server and ~3000 games and 
score from 
db. Try to open TOP or Monthly TOP or Player Stat and my server dies with 100% 
load, 
only stop the mysql server helps...

Original comment by megli...@gmail.com on 26 Jan 2010 at 1:51

[GoogleCodeExporter]

hi guy's,

our bot project got ~143.000 games stored in the database since oct 2009.
we've to disable pages like "top hero" "top players" ... because the queries 
could
take down our quadcore machine :(

if you need a databasedump for testing this environment, feel free to contact 
me.
we love your work and the "allstats" dota-statistics is the best solution i've 
found
on the net!

btw: is there any way to support you project? donations or anything else? 

best regards, thank you!

Original comment by tigaa...@gmail.com on 5 Feb 2010 at 8:48

[GoogleCodeExporter]

In fact, my friends and I have did some optimization for the top players, top 
heroes
page. It's simple, I add two tables for players and heroes to save the total 
games,
kill, deaths... We process each new dota game record timely, and update the two
tables, of course I modified the sql in the top.php.
Now the page is: http://cslab.nju.edu.cn:82/Allstats/  (maybe a little slower 
'cause
the network latency)

Original comment by zwd2...@gmail.com on 5 Feb 2010 at 9:00

[GoogleCodeExporter]

hmmm can't reach the server :(
but your basic idea is good

Original comment by tigaa...@gmail.com on 5 Feb 2010 at 6:25

[GoogleCodeExporter]

I am having the problems with a relatively large database :). We are having 
20,000 
games statted online.

Original comment by Hendric...@gmail.com on 27 Feb 2010 at 3:09

[GoogleCodeExporter]

I now ran the optimizeSQL.sql and it runs way better, still lags slightly 
though.

Original comment by Hendric...@gmail.com on 14 Mar 2010 at 2:22

[GoogleCodeExporter]

I have 61000 games in the database same thing timed out in montly tops and top 
players...etc

Original comment by Ile.Nob...@gmail.com on 30 Dec 2010 at 8:05