vb.org Archive - Identifying query intensive mod?

Page 3 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Identifying query intensive mod? (https://vborg.vbsupport.ru/showthread.php?t=161398)

Mellow

10-30-2007 11:01 AM

Quote:

Originally Posted by Paul M (Post 1371328)

The dateline index does not exist in default vb, I think the mod included instructions to add it at one point but I'm not sure.

Anyway, just use this SQL command ;

[sql]ALTER TABLE post ADD INDEX (dateline) ;[/sql]

However, since you are both running vb 3.6, so you should really be running this version of the mod (which as I said, creates the index automatically).

https://vborg.vbsupport.ru/showthread.php?t=123886

The version you are currently using is very old.

Paul, what's the difference between the one you posted and this one:
https://vborg.vbsupport.ru/showthread.php?t=123931

It seems they are both for the welcome box and 3.6.x.. ???

Tourmeister

10-30-2007 03:55 PM

I reinstalled the old version. It's working perfectly for me and the query time/server load is very low. I very rarely see a query last over 1 second when monitoring with mtop.

Mellow, whichever version you have installed now seems to be working pretty well. I am still seeing the occasional appearance of STO queries over 1 second, but the server loads are still staying around .50 and lower.

Strange that the newest version would make both of our sites start banging out really long queries?

All times are GMT. The time now is 03:16 PM.

Page 3 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01281 seconds Memory Usage 1,715KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: