vb.org Archive - View Single Post - Whats the Top 10 worst hacks 4 server load?

thincom2000 · #81 01-19-2007, 03:20 AM

Does that say 15 seconds? Server load 7.85?! I only get server loads that high on MediaWiki pages (and I have no idea why, hopefully they reduced queries in the PHP 5 versions).

With respect to the realtime pagecompressor, some hosts do not have gzip enabled on their servers, and do not offer php.ini access to turn this on. Is the pagecompressor mod a decent alternative for these users, or does its effect on server load make it recommended to not use anything in these cases?

Also, I have been writing a hack that definitely needs its own table in the database. The hack adds 1 query to pages it's used on. It was suggested to me to instead save the database table as an array in a datastore field. I fear that some users may end up with hundreds of rows in their tables, and "querying" arrays does not have the same simplicity as MySQL. How much additional memory usage would you say is comparable to 1 MySQL query?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01255 seconds Memory Usage 1,761KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: