Yes, do I send it to support@grabaperch.com? I actually sent it back on 12/16, subject is "Perch to Runway upgrade more than doubled DB size". I can resend if needed. Just let me know what other access you need. Thanks Drew.
Looks like you've got a duff index. Try these two statements on your dev site and see if they make an improvement.
ALTER TABLE `perch2_resource_log` DROP INDEX `idx_uni`;
ALTER IGNORE TABLE `perch2_resource_log` ADD UNIQUE INDEX `idx_uni` (`appID`, `itemFK`, `itemRowID`, `resourceID`);
Can I provide access, or continue support for this some other way? My client is getting irritated by the slow performance of the site.
Yes, I'll need some sort of access - otherwise I'm just making blind guesses. Can you send me a copy of the database?
Yes, do I send it to support@grabaperch.com? I actually sent it back on 12/16, subject is "Perch to Runway upgrade more than doubled DB size". I can resend if needed. Just let me know what other access you need. Thanks Drew.
Ok, got it, thanks.
Looks like you've got a duff index. Try these two statements on your dev site and see if they make an improvement.
Here was the output:
Regions seem to be saving much faster now! The site seems to be functioning normally. Any possible side effects I should watch out for?
That cleared up 1.4 million duplicate rows, so it should be faster.
The data was redundant, so you should be fine.
Awesome, thank you Drew! Do you think this was caused by PHP out-of-memory errors when images that are too large choke the image resizer?
No, it was an issue with the index on the table - I'm not sure why it wasn't unique, but it should be fine now.