자바에서 정렬하기 vs DB에서 정렬하기

@Transactional(readOnly = true)
@MeasureTime
public List<PickResult.FolderPickList> getFolderListChildPickList(PickCommand.ReadList command) {
    return command.folderIdList().stream()
	.peek(folderId -> validateFolderAccess(command.userId(), folderId))  // 폴더 접근 유효성 검사
	.map(this::getFolderChildPickResultList)
	.toList();
}

private PickResult.FolderPickList getFolderChildPickResultList(Long folderId) {
    Folder folder = folderDataHandler.getFolder(folderId);
    List<Pick> pickList = pickDataHandler.getPickListPreservingOrder(folder.getChildPickIdOrderedList());
    List<PickResult.Pick> pickResultList = pickList.stream()
	    .map(pickMapper::toPickResult)
	    .toList();
    return pickMapper.toPickResultList(folderId, pickResultList);
}

@MeasureTime
public List<PickResult.Pick> getPickList(Long userId, List<Long> folderIdList) {
    if (folderIdList == null || folderIdList.isEmpty()) {
	    return List.of();
    }
    
    List<Long> pickIdList = folderIdList.stream()
	    .flatMap(folderId -> getChildPickIdOrderedList(folderId).stream())
	    .toList();
    
    if (pickIdList.isEmpty()) {
	    return List.of();
    }
    
    String orderListStr = pickIdList.stream()
	    .map(String::valueOf)
	    .collect(Collectors.joining(", "));
    
    Expression<Integer> orderByField = Expressions.template(Integer.class,
	    "FIELD({0}, " + orderListStr + ")", pick.id);
    
    OrderSpecifier<Integer> orderSpecifier = new OrderSpecifier<>(Order.ASC, orderByField);
    
    return jpaQueryFactory
	    .select(pickResultFields())
	    .from(pick)
	    .where(
		    userEqCondition(userId)
	    )
	    .orderBy(orderSpecifier)
	    .fetch();
}

private List<Long> getChildPickIdOrderedList(Long folderId) {
    return jpaQueryFactory
	    .select(folder.childPickIdOrderedList)
	    .from(folder)
	    .where(folder.id.eq(folderId))
	    .fetchOne();
}

Java Sort -> getFolderListChildPickList 실행 시간 : 14 ms 
DB Fleid -> getPickList 실행 시간 : 65 ms