Jackson Whelan

Speeding Up WP E-Commerce Shopping Cart… a bit

February 17th, 2009

updating_tasks.php line 396
if($wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}currency_list WHERE continent NOT IN ('')") < 242)
to
if($wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}currency_list WHERE continent NOT IN ('')") < 230)
I went from 330 queries to 86!

http://www.instinct.co.nz/forums/topic.php?id=2856#post-13720

Posted in WordPress, mysql, wpsc | Comments Off