Support » Plugin: Custom Field Template » [Plugin: Custom Field Template] Crippled performance add indexes to join

  • When loading the blog posts from wp-admin the performance is crippled with this plugin activated.

    Currently it is not suitable for high performance environments.

    When performing this piece of code:

    custom-field-template.php:3723

    $sql = $wpdb->prepare(" LEFT JOIN” . $wpdb->postmeta . “AS meta ON (” . $wpdb->posts . “.ID = meta.post_id AND meta.meta_key = %s)", $_REQUEST['orderby']);

    You need to add indexes.

    Can you fix this please?

    Thanks

    http://wordpress.org/extend/plugins/custom-field-template/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Dave Ligthart

    (@daveligthart-1)

    It seems that the indexes got removed somehow on our db server.

    Adding the indexes did increase performance; however the posts are still loading very slowly.

    Thread Starter Dave Ligthart

    (@daveligthart-1)

    I have removed the custom columns from the post and page list. This solved the performance issue.

    Please consider removing this code from the plugin.

    custom-field-template.php

    /* add_action( 'manage_posts_custom_column', array(&$this, 'add_manage_posts_custom_column'), 10, 2 );
    add_filter( 'manage_posts_columns', array(&$this, 'add_manage_posts_columns') );
    add_action( 'manage_pages_custom_column', array(&$this, 'add_manage_posts_custom_column'), 10, 2 );
    add_filter( 'manage_pages_columns', array(&$this, 'add_manage_pages_columns') );
    */

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: Custom Field Template] Crippled performance add indexes to join’ is closed to new replies.