my error log is showing lots of errors to do with memory exceeded.
I believe it is to do with the fact that I have over 43,000 registered user accounts with over 535,000 rows in wp_usermeta
any time that I go to edit a post by a contributor the select author drop down box would take an age to render so I wrote a plugin to remove the authordiv meta box and replace it with one that only shows contributors.
the problem still persists though due to other core files using wp_list_authors which I think is the function that is consuming so much memory
here is a few lines from my error log
[25-Jun-2011 11:20:38] WordPress database error MySQL server has gone away for query SELECT COUNT(ID) FROM wp_users made by require, require_once, include, genesis, do_action, call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once, do_action, call_user_func_array, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Text->widget, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, cl_login_box [25-Jun-2011 11:20:55] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 64 bytes) in /home/comluv/public_html/wp-includes/meta.php on line 341 [25-Jun-2011 11:21:43] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 82 bytes) in /home/comluv/public_html/wp-includes/wp-db.php on line 1400 [25-Jun-2011 11:23:43] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /home/comluv/public_html/wp-includes/meta.php on line 344
what can I do about this, I have upped my php memory limit from 64 to 128 to 256M but still the error persists. Just how much memory do I need for that kind of user table?