Re: War2 Analytics
« Reply #9 on: February 19, 2016, 01:10:11 PM »
Lance, I could definitely use some help with speeding this site up.
The server is 8gb RAM, 500GB sata hdd, 2 Xeon CPUs, there's no reason it should be so slow I would think.
backend: Linux/CentOS, Apache, MySQL, PHP, Python (for scraping all the data and adding to my DB)
I just barely started to get into programming and databases last spring, I didn't even know what a "framework" like Laravel was until after I started this site, so its just a mess of different PHP files strung together with "include"s.
Python scripts run on a 3min cronjob for collecting game reports and server status info and adding to my own DB.
I've made some changes in MySQL because it is so slow I've been trying to make it better, I increased some table size memory or something that helped alot for when I do subqueries that select huge tables "AS table_1" for example.
Also I changed to "innodb" just because I read its better but like I said I dont know much like how to cache, but Ill look into it
I need help writing the game search also.
Figuring out the query to write was very complex, joining multiple databases, but I have it figured out now. The problem is the number of possible combinations of inputs is insane.
Do I literally need to have an ifelse statement for every possible combination of inputs? If so I will literally have to write thousands of ifelse statements to expand to 8 players