Hand-write a plugin to add a timestamp to the end of uploaded filenames to prevent excessive SQL queries
Repost license
Request authorization before reposting and retain the authorization code, original URL, and go/affiliate links.
Original URL:https://www.geekcorelab.com/post/handwritten-plugin-adds-a-timestamp-to-the-end-of-uploaded
The commercial link is an authorized go short link that must stay on the reposted page. It records the source before sending readers to the original article.
In the WordPress Media Library, when a file is uploaded, it first queries the database to check whether a file with the same filename exists; if it does, it continues to query the next filename
This causes the number of SQL requests to keep increasing after repeatedly uploading a file with the same filename (even if the file contents are different)
Many plugins currently either prepend a timestamp to the filename or directly rename the filename to a timestamp, which makes finding files very difficult. For this reason, I recommend getting the extension, adding a timestamp to the end of the filename, and then appending the extension back. Below is the complete code; you can test it freely in this temporary WordPress environment
If you do not yet have your own WordPress site, you can use a 雨云 server to quickly build one
Comments
Discussion
Be kind and keep the discussion friendly.
Discussion
0 comments