Help! stats_get_csv() is killing my download speed in my plugin 😫

[ad_1]

I’m building a plugin that exports posts to a CSV. The thing is, I’m using the stats\_get\_csv() function from Jetpack to get the views for each post, and it’s slowing down my download speed to 100 Bytes/s. It’s a disaster.

What I’ve already tried and didn’t work:

1. I tried doing a direct SQL query to get the post views instead of calling stats\_get\_csv() for each one. But it didn’t work because it fetches different views, not the same ones.
2. I thought about using transients to cache the results of stats\_get\_csv() and avoid repeated calls during the export. But nope, it didn’t improve things.
3. I attempted to fetch all the data at once to avoid multiple requests. But I get a timeout before I can export. It’s a bummer.

Honestly, I don’t know what else to try. I feel like the meme of the guy looking at the piece of paper with a suffering face.

If anyone has any ideas or experience with this function and can lend me a hand, I’ll be eternally grateful. I need to solve this, otherwise my plugin is going to be slow as hell.

Thanks in advance!

My function to get views:

function get\_page\_views($post\_id) {

$cache\_key = ‘post\_views\_’ . $post\_id;

$views = wp\_cache\_get($cache\_key);

if ($views === false) {

if (function\_exists(‘stats\_get\_csv’)) {

$args = array(‘days’=>-1, ‘limit’=>-1, ‘post\_id’=>$post\_id);

$result = stats\_get\_csv(‘postviews’, $args);

$views = intval($result\[0\]\[‘views’\]);

} else {

$views = 0;

}

wp\_cache\_set($cache\_key, $views, ‘post\_views’, 300);

}

return $views;

}

part of my export function:
foreach ($results as $post) {

$views = wp\_cache\_get(‘post\_views\_’ . $post->ID);

if ($views === false) {

$views = get\_page\_views($post->ID);

error\_log(‘Visitas obtenidas de la forma original para el post\_id: ‘ . $post->ID . ‘, visitas: ‘ . $views);

} else {

error\_log(‘Visitas obtenidas de la caché para el post\_id: ‘ . $post->ID . ‘, visitas: ‘ . $views);

}

fputcsv($output, array(

$post->ID,

$post->post\_title,

get\_the\_author\_meta(‘display\_name’, $post->post\_author),

implode(‘, ‘, wp\_get\_post\_categories($post->ID, \[‘fields’ => ‘names’\])),

$views,

$post->post\_date

));

ob\_flush();

flush();

}

[ad_2]