After jumping through several hoops I was able to get our databases back to working order. We will no longer retain pokemon data beyond 3 days as it bogs scans down. The benefit is faster map access and reliable synchronization between scan databases and map databases. Because we no longer retain data beyond 3 days, pokemon stats cannot be long-lived and we cannot view historical data for analysis. I will be working with developers of the software to assist with the back-end design to allow for large map implementations such as ours.
Go get some ‘mons!