WordPress.org
Get WordPress

Plugin Directory

Changeset 1454235


Ignore:
Timestamp:
07/13/2016 05:24:36 PM (10 years ago)
Author:
bhavinder
Message:

Optimize Query for BackEnd Process

Location:
wp-super-speed/trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • wp-super-speed/trunk/readme.txt

    r1452047 r1454235  
    6565= 1.0 =
    6666* First version uploaded to wordpress directory
     67= 1.1 =
     68* Delete unused post meta and optimise database.
    6769
    6870== Upgrade Notice ==
    69 
    7071= 1.0 =
    7172It's a first version.
     73= 1.1 =
     74* Delete unused post meta and optimise database.

  • wp-super-speed/trunk/wp-super-speed.php

    r1451882 r1454235  
    33Plugin Name: WP Super Speed
    44Description: This powerful plugin dramatically reducing CPU and RAM utilazation by 70-80%. Just install and activate it and in return get an optimized and speedy version of your website backend as well as front end. Surely you’ll find a difference due to its presence.
    5 Version: 1.0
     5Version: 1.1
    66Author: Bhavinder Singh
    77License: GPL2
    … …  
    1414
    1515global $wpdb;
    16 
     16//Extra indexes improve your server performance
    1717$querystr = "ALTER TABLE $wpdb->posts ADD INDEX(ID, post_date, post_status, post_name, post_modified, guid, post_type);";
    1818$pageposts = $wpdb->get_results($querystr, OBJECT);
    … …  
    3737$querystr = "ALTER TABLE $wpdb->users ADD INDEX(ID, user_login, user_email, user_status);";
    3838$pageposts = $wpdb->get_results($querystr, OBJECT);
     39//Optimize Query for BackEnd Process
    3940$querystr = "ALTER TABLE $wpdb->usermeta ADD INDEX(umeta_id, user_id, meta_key);";
    4041$pageposts = $wpdb->get_results($querystr, OBJECT);
     42
    4143
    4244 
Note: See TracChangeset for help on using the changeset viewer.