thesoundbully39
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] checkout.js shortcode sending console errorsSame issue here. On Checkout page when attempting to go to payment. The issue disappears when the Create New Account? checkbox is checked and unchecked.
I think it’s trying to validate the password field but failing.
How does the paid version differ for divi support? Does it use faster queries than the existing that contain LIKE?
So, to answer my own question (kind of). The slowness is because a different method needs to be used to find the media ID due to how Divi stores data.
However, I have replaced the MySQL query in the get_source_id_by_remote_url() function within item.php that contains LIKE (super slow) and have shaved that 5-6 seconds off of the queries…
Please tell me the drawback of what I’ve done!!
/* ORIGINAL BEFORE MODIFIED BY TYLER TO REDUCE MYSQL LIKE QUERY $sql = $wpdb->prepare( "SELECT * FROM " . static::items_table() . " WHERE source_type = %s AND (path LIKE %s OR original_path LIKE %s);" , static::$source_type , '%' . $path , '%' . $path ); MODIFIED BELOW */ $sql = $wpdb->prepare( "SELECT * FROM " . static::items_table() . " WHERE source_type = %s AND path = %s;" , static::$source_type , '%' . $path , '%' . $path ); /* END MODIFICATION */
Hmm.. so I noticed that on the production site it does not use the same query.. no LIKE in the statements. Why would it be different? Divi?