Optimize scan for lost attachments
|Reported by:||johnjosephbachir||Owned by:||westi|
This patch moves all of the logic for scanning for lost attachments to the DB.
The code is more simple, and from my simple but repeated tests, the performance is significantly improved (done against a pretty sizeable posts table).
We could do it in one query instead of two if WordPress required MySQL 4.1, but subqeuries are not supported in 4.0 so we have to do it in two.
The patch was made against trunk, revision 11997 (last change to update.php, 11013)
Let me know if you have any questions or suggestions.
Change History (22)
- Resolution fixed deleted
- Status changed from closed to reopened