|
Well, I was wrong. It was good to get the older version of the PHPAds software out of the system and clean up other problems, but we still had a slowdown today. The good news is I know *exactly* where the problem lies. It's with a search query on the Peach Database. For some reason, the Pelican database (running on the same server with the same installation of MySQL) doesn't have the same problems (I ran the query on Peach - it took more than 180 seconds before I killed it - ran the same query on Pelican, it took 2 seconds). I've spent 10 years tweaking the Pelican database, so I will compare the two and figure out what the exact issue is...
EDIT: I just compared the two databases, and there are a lot of database indexes that I added to Pelican that are not in the Peach Catalog. I will add those tonight (have to bring down the site to do that)
-Wayne
|