Line 186 bp-activity-classes.php – SELECT *
-
From Line 186 of the bp-activity-classes.php:
$activities = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM {$bp->activity->table_name} WHERE id IN ({$activity_ids}) ORDER BY date_recorded {$sort} $pag_sql” ) );
I’m just learning here (so please be gentle) – is there a reason the SELECT * is used rather than specific tables? Is the * necessary? I’m just curious as I’m reading the code to see what’s there … because isn’t * taxing to the server and faster to provide the specific tables?
-
Figures I’d use the wrong word “tables” versus “fields” … I knew what I meant .. but am clearly a novice
OK. I was reading that SELECT * is taxing on the server and it’s better to specify the “fields” .. so in that statement … are all the fields required?
Thanks Jeff for the link. In fact, in that example:
SELECT Company, Country FROM Customers WHERE Country ‘USA’
See how they don’t use SELECT * but SELECT Company, Country … that’s really my question for learning today
Thank you. It’s all about learning
- The topic ‘Line 186 bp-activity-classes.php – SELECT *’ is closed to new replies.
