I have done as you instructed with is_user_loggdin() but now how can I resolve the performance issue with count_user_posts and simplify the code

Thanks

Will this code work

 /** 
 * Custom function to count user posts and cache the result using transients
 */
function custom_count_user_posts($user_id) {
    $post_count = get_transient('custom_user_post_count_' . $user_id);

    if (false === $post_count) {
        $post_count = count_user_posts($user_id);
        set_transient('custom_user_post_count_' . $user_id, $post_count);
    }

    return $post_count;
}

/** BuddyPress Auto Friendship Pro + BuddyPress Featured Members autofollow. */
function auto_follow_on_welcome_page_load() {
    // Check if the current page slug matches 'welcome'
    if (is_page('welcome')) {
        if (!function_exists('bp_follow_start_following')) {
            return;
        }

        $user = wp_get_current_user();

        // Check if the user has no last activity and hasn't already performed the follow action
        if (empty(bp_get_user_last_activity($user->ID)) && !get_user_meta($user->ID, 'has_followed_featured_users', true)) {

            global $wpdb;

            $featured_user_ids = $wpdb->get_col(
                $wpdb->prepare(
                    "
                    SELECT user_id
                    FROM {$wpdb->usermeta}
                    INNER JOIN {$wpdb->users} ON {$wpdb->usermeta}.user_id = {$wpdb->users}.ID
                    WHERE {$wpdb->usermeta}.meta_key = %s
                    AND {$wpdb->usermeta}.meta_value = %s
                    AND {$wpdb->users}.user_status = %d
                    ",
                    '_is_featured',
                    '1',
                    0
                )
            );

            $users_more_than_2_posts = array();
            foreach ($featured_user_ids as $featured_user_id) {
                $post_count = custom_count_user_posts($featured_user_id);
                if ($post_count > 2) {
                    $users_more_than_2_posts[] = $featured_user_id;
                }
            }

            $total_featured_users = count($users_more_than_2_posts);
            $selected_user_ids = $users_more_than_2_posts;
            if ($total_featured_users > 10) {
                shuffle($users_more_than_2_posts);
                $selected_user_ids = array_slice($users_more_than_2_posts, 0, 9);
            } else if ($total_featured_users > 5) {
                shuffle($users_more_than_2_posts);
                $selected_user_ids = array_slice($users_more_than_2_posts, 0, 6);
            } else if ($total_featured_users < 5) {
                shuffle($users_more_than_2_posts);
                $selected_user_ids = array_slice($users_more_than_2_posts, 0, 3);
            }

            foreach ($selected_user_ids as $featured_user_id) {
                bp_follow_start_following(array(
                    'leader_id' => $featured_user_id,
                    'follower_id' => $user->ID,
                ));
            }

            // Set a user meta flag to indicate that the follow action has been performed
            update_user_meta($user->ID, 'has_followed_featured_users', true);
        }
    }
}
add_action('template_redirect', 'auto_follow_on_welcome_page_load');