Hand-write a plugin to add a timestamp to the end of uploaded filenames to prevent excessive SQL queries

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

Article repost policy

Request authorization before reposting and retain the authorization code, original URL, and go/affiliate links.

Original URL: https://www.geekcorelab.cn/en-US/post/handwritten-plugin-adds-a-timestamp-to-the-end-of-uploaded