effiency has its limits.PHP are not the issue, making efficient SQL queries on limited resources is.
If the amount of raw data is huge enough, every server gets slow.
And when you log every public, leageu and PUG match, the data is incredible much.
One possible way is to reduce database joins and queries as much as possible (fuck the normalization)
Also limit the possibility of fllexibel searches. (ie. replace "like" with "=" or placeholders)
Another good way is to create an archive table. So (for example) every month the data from the current datatable gets transfered into the archives, meaning that current stats will be queried much much faster.
but i suppose you knew that or even tried it alrdy.
Last edited: