WordPress批量自动添加图片alt标签优化求助

问题背景 #

我写了一段WordPress代码，用来检查图片并自动从图片名称生成Alt标签，功能正常但不管怎么调整都消耗过多服务器资源，要处理4万张图片，求优化方案，方案也要能帮到有大量图片的用户。

原代码 #

// Set the number of images to process per batch
$batch_size = 2;

// Set the page number to start from
$page_number = 1;

// Set a flag to indicate if there are more images to process
$more_images = true;

// Loop through each batch of images
while ($more_images) {
// Get the current batch of images
$images = get_posts([
"post_type" => "attachment",
"post_mime_type" => "image",
"posts_per_page" => $batch_size,
"orderby" => "ID",
"order" => "DESC",
"paged" => $page_number,
]);
// Check if there are any images in the batch
if (!empty($images)) {
// Initialize an array to store the image IDs and alt tags
$image_data = [];
  // Loop through each image in the batch
  foreach ($images as $image) {
       // Get the image ID
       $post_ID = $image->ID;

       // Check if the image has an empty alt tag
       $alt = get_post_meta($post_ID, "_wp_attachment_image_alt", true);
       if (empty($alt)) {
            // Get the image title
            $my_image_title = get_post($post_ID)->post_title;

            // Sanitize the title: remove hyphens, underscores & extra spaces
            $my_image_title = preg_replace(
                 "%\s*[-_\s]+\s*%",
                 " ",
                 $my_image_title
            );

            // Sanitize the title: capitalize first letter of every word (other letters lower case):
            $my_image_title = ucwords(strtolower($my_image_title));

            // Store the image ID and sanitized title in the image data array
            $image_data[$post_ID] = $my_image_title;
       }

       // Add a 2-second work break between two images
       sleep(2);
  }

  // Update the alt tags for all images in the batch
  foreach ($image_data as $post_ID => $alt_tag) {
       update_post_meta(
            $post_ID,
            "_wp_attachment_image_alt",
            $alt_tag
       );
  }

  // Increment the page number
  $page_number++;
} else {
// Set the flag to indicate that there are no more images to process
$more_images = false;
}

// Pause for a few seconds before moving on to the next batch
sleep(5);
}

优化方案 #

• 移除无意义的sleep等待：原代码每张图片间隔2秒、每批间隔5秒的等待完全没必要，会大幅拉长处理时间且占用服务器资源，直接删除这些sleep()调用。
• 提升批量处理规模：把$batch_size从2调整为50-100（可根据服务器性能微调），减少数据库查询的次数，降低连接开销。
• 查询阶段直接筛选目标图片：通过meta_query直接过滤出没有Alt标签（或标签为空）的图片，不用拉取所有图片再逐一判断，减少内存占用和循环工作量。
• 避免重复的Post查询：原代码里get_post($post_ID)->post_title是冗余操作，$image本身就是Post对象，直接用$image->post_title即可。
• 批量更新元数据：用WordPress的update_metadata_batch()函数替代循环调用update_post_meta()，减少数据库操作次数，提升效率。
• 关闭WP查询的冗余功能：在get_posts参数中添加'no_found_rows' => true（不需要总计数）和'update_post_meta_cache' => false（不需要缓存元数据），进一步优化查询性能。

优化后的代码 #

// 批量处理数量，根据服务器性能调整（建议50-100）
$batch_size = 100;
$page_number = 1;
$more_images = true;

while ($more_images) {
    $images = get_posts([
        "post_type" => "attachment",
        "post_mime_type" => "image",
        "posts_per_page" => $batch_size,
        "orderby" => "ID",
        "order" => "DESC",
        "paged" => $page_number,
        "no_found_rows" => true, // 关闭总计数查询，提升效率
        "update_post_meta_cache" => false, // 不需要缓存元数据，节省内存
        "meta_query" => [
            [
                "key" => "_wp_attachment_image_alt",
                "compare" => "NOT EXISTS", // 筛选没有Alt标签的图片
                "value" => "",
                "type" => "CHAR"
            ],
            "relation" => "OR",
            [
                "key" => "_wp_attachment_image_alt",
                "compare" => "=", // 筛选Alt标签为空的图片
                "value" => "",
                "type" => "CHAR"
            ]
        ]
    ]);

    if (!empty($images)) {
        $image_data = [];
        foreach ($images as $image) {
            $post_ID = $image->ID;
            // 直接复用已有的post对象获取标题，避免重复查询
            $my_image_title = $image->post_title;
            
            // 清理标题格式
            $my_image_title = preg_replace("%\s*[-_\s]+\s*%", " ", $my_image_title);
            $my_image_title = ucwords(strtolower($my_image_title));
            
            $image_data[$post_ID] = [
                "_wp_attachment_image_alt" => $my_image_title
            ];
        }

        // 批量更新元数据，减少数据库操作
        if (!empty($image_data)) {
            update_metadata_batch('post', $image_data);
        }

        $page_number++;
    } else {
        $more_images = false;
    }
}

内容的提问来源于stack exchange，提问作者Luk