WordPress.org
Get WordPress

Plugin Directory

Changeset 217801


Ignore:
Timestamp:
03/15/2010 05:41:58 PM (16 years ago)
Author:
anukit
Message:

making the function db_stats more efficient - seeing if it can use only one database query instead of 7!

File:
1 edited

Legend:

Unmodified
Added
Removed

  • cyclopress/branches/cp2/classes/cyclopress.php

    r217788 r217801  
    26002600            $where = '';
    26012601        }
    2602    
     2602       
     2603        // generate the sql
     2604        $sql  = 'select avg(avg_speed) as avg_avg_speed,';
     2605        $sql .= 'sum(miles) as total_miles, ';
     2606        $sql .= 'sum(minutes) as total_time, ';
     2607        $sql .= 'count(*) as total_rides, ';
     2608        $sql .= 'max(max_speed) as max_max_speed, ';
     2609        $sql .= 'min(startdate) as since ';
     2610        $sql .= 'from '.$table_name.$where;
     2611       
     2612        // get the stats
     2613        $result = $wpdb->get_results($sql, ARRAY_A);
     2614        if (!$result) {
     2615            return false;
     2616        }
     2617        $stats = $result[0];
     2618       
     2619        /*
    26032620        $sql  = 'select * from '.$table_name.$where.' order by startdate desc limit 1';
    26042621        $result = $wpdb->get_results($sql, ARRAY_A);
    … …  
    26432660        $row = $result[0];
    26442661        $stats['max_max_speed'] = $row['max_max_speed'];
     2662        */
    26452663       
    26462664        return $stats;
Note: See TracChangeset for help on using the changeset viewer.