WordPress.org

Ready to get started?Download WordPress

Forums

Custom Field Template
Crippled performance add indexes to join (3 posts)

  1. daveligthart
    Member
    Posted 2 years ago #

    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/

  2. daveligthart
    Member
    Posted 2 years ago #

    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.

  3. daveligthart
    Member
    Posted 2 years ago #

    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') );
    */

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic