A New Database Cleaning Command
At work today, one of the other programmers found where Postgres' "analyze table" function will rebuild table indexes, speeding things up a lot. I'm using something similar for BZP's database, but not the exact same thing. So I added the mySQL "analyze table" function to my DB cleaner and ran it, and it seems to have sped things up a bit. I've just finished, so I'll give it a few days to really kick in. Hopefully this will help with the server latency issues.
9 Comments
Recommended Comments