Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Performance #17

Open
GoogleCodeExporter opened this issue Mar 27, 2016 · 8 comments
Open

Performance #17

GoogleCodeExporter opened this issue Mar 27, 2016 · 8 comments

Comments

@GoogleCodeExporter
Copy link

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
Copy link
Author

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
Copy link
Author

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
Copy link
Author

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
Copy link
Author

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
Copy link
Author

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
Copy link
Author

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
Copy link
Author

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
Copy link
Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant