Question 175036 in Woocommerce Question posted in
The official Woocommerce documentation can be found here.

What is the best way to rewrite? What’s the best way to rewrite?

This is a WordPress with Woocommerce project.

I have to loop an array with more than 200 thousand of items. Every item is an order’s ID in the data base. I have to sum the value of every order’s meta to get the total sum. But the loop allways ends with memory issue.

Here is my code:

function woq_orders_total(){
    $orders = get_option( 'woq_orders_ids' ); // array of IDs
    $meta = array();

    $i = 0;
    foreach( $orders as $order ) :
        $meta[] = get_post_meta( $order, '_order_total', true );
        if ( $i % 500 == 0 )
            sleep( 5 ); // stop for 5 seconds every 500 items

        $i++;
    endforeach;

    update_option( 'woq_orders_total', array_sum( $meta ) );
}

I’ve try stoping every 100 items, but the problem persists. This works well with a few numbers of items, but not with this big amount.

Thanks for any help

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I've found a solution thanks to the comment by Markus AO

    Now my code looks like this:

    function woq_orders_total(){
    global $wpdb;
    $orders = get_option( 'woq_orders_ids' );
    $orders = join( ',', $orders );
    $meta_key = '_order_total';

    $total = $wpdb->get_var(
        $wpdb->prepare(
            "
            SELECT SUM(meta_value)
            FROM $wpdb->postmeta
            WHERE meta_key = %s
            AND post_id IN ({$orders})
            ",
            $meta_key
        )
    );

    update_option( 'woq_orders_total', $total );
}

    Also these comment in $wpdb documentation help a lot https://developer.wordpress.org/reference/classes/wpdb/#comment-1975

    Thanks you all.


  2. 0

    You don’t have to read all the data into the array to sum them up.
    You only need to store the sum.

    function woq_orders_total(){
    $orders = get_option( 'woq_orders_ids' ); // array of IDs
    $total = 0;

    foreach( $orders as $order ) :
        $total += (float)get_post_meta( $order, '_order_total', true );
    endforeach;

    update_option( 'woq_orders_total', $total);
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search