scalable-wp-queries.php

scalable-wp-queries.php

<?php

$max_results_per_query = 200;
$offset = 0;
$has_more_results = true;

while($has_more_results) {

	$args = [
		'post_type' => 'example-post-type',
		'post_status' => 'publish',
		'posts_per_page' => $max_results_per_query,
		'offset' => $offset,
		'fields' => 'ids',
		'orderby' => 'ID',
		'order' => 'ASC',
	];

	$query = new WP_Query($args);

	if(empty($query->posts)) {
		$has_more_results = false;
		continue;
	} else {
		$offset += $max_results_per_query;
	}

	foreach($query->posts as $post_id) {

		// don't use models here
		$post = get_post($post_id);
		$post_meta = get_post_meta($post_id);

		// write excel row

		\Globalis\WP\Cubi\flush_cache_all();
	}
}