🐞 검색엔진 타임아웃 문제 해결 - Sitemap 성능 최적화

import { MetadataRoute } from "next";

// export const dynamic = 'force-dynamic'; 기존 SSR 설정 
export const dynamic = 'force-static'; // SSG 방식으로 전환 

@Query("""
    SELECT new com.pyomin.cool.dto.SitemapDto(
      p.slug,
      COALESCE(p.updatedAt, p.createdAt)
    )
    FROM Post p
    WHERE p.status = :status
    ORDER BY COALESCE(p.updatedAt, p.createdAt) DESC, p.id DESC
    """)
List<SitemapDto<String>> findAllForSitemap(PostStatus status);

package com.pyomin.cool.dto;

import java.time.Instant;
import java.time.LocalDateTime;
import java.time.ZoneId;

public record SitemapDto<K>(K key, Instant lastModified) {
  
  public SitemapDto(K key, LocalDateTime lastModifiedLdt) {
    this(
      key,
      lastModifiedLdt == null
        ? null
        : lastModifiedLdt.atZone(ZoneId.of("Asia/Seoul")).toInstant()
    );
  }
}

import { MetadataRoute } from "next";
import { getApiBase } from "@/lib/api/apiBase";

export const revalidate = 86400; // ISR (하루마다 재생성)

const SITE_URL = 'https://pyomin.com';

type SlugSitemap = { slug: string; lastModified: string };
type SitemapResponse<T> = { sitemap: T[] };

async function fetchPostSitemap(): Promise<SlugSitemap[]> {
  const res = await fetch(`${getApiBase()}/posts/sitemap`);
  if (!res.ok) throw new Error('posts/sitemap 실패');
  
  const json = (await res.json()) as SitemapResponse<SlugSitemap>;
  return json.sitemap ?? [];
}

// 카테고리 fetch 생략

export default async function sitemap(): Promise<MetadataRoute.Sitemap> {
  const [posts, categories] = await Promise.all([fetchPostSitemap(), fetchCategorySitemap()]); // 동시 호출
  
  const postPages: MetadataRoute.Sitemap = posts.map((post) => ({
    url: `${SITE_URL}/posts/${encodeURIComponent(post.slug)}`,
    lastModified: post.lastModified,
    changeFrequency: 'monthly',
    priority: 0.8,
  }));
  
  // 이 외 사이트맵 생성 및 return
}