Hand-write a plugin to add a timestamp to the end of uploaded filenames to prevent excessive SQL queries
Repost license
转载需先申请授权，并保留授权码、原文地址和文中 go/affiliate 链接。
Original URL:https://www.geekcorelab.com/post/handwritten-plugin-adds-a-timestamp-to-the-end-of-uploaded
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