vb.org Archive - Admin Quick Stats

Page 5 of 12

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

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Admin Quick Stats (https://vborg.vbsupport.ru/showthread.php?t=37193)

FWC	04-11-2002 06:23 AM

Cool. I'm glad it worked. It's a great hack!

ryanhulce

04-11-2002 06:26 AM

Here is what Opera Showed!

inphinity

04-11-2002 11:43 AM

nice hack freddy :)

on my board i've found that it slows the loading of the admin page by a few seconds and also adds to the load of the machine.

so i've moved it to a seperate file and added a link to my admin nav bar :)

Save Freddys hack to admin/adminquickstats.php at the top of the file add:

PHP Code:


		
			
<?php



error_reporting(7);



require("./global.php");



cpheader();

and the bottom of the file add

PHP Code:


		
			
cpfooter();



?>

In admin/index.php find

PHP Code:


		
			
makenavoption("Back-up Database","backup.php?action=choose","<br>");

above it add

PHP Code:


		
			
makenavoption("Database Stats","adminquickstats.php?action=","<br>");

Freddie Bingham

04-11-2002 01:22 PM

Yes it will do a full scan of the post/thread/user tables so it can appear slow. I don't see any long term effects on load happening though unless you are reloading the Admin CP index often.

Harvey

04-11-2002 03:25 PM

Hi,

I don't reccoment if you don't call admin/index.php every few seconds, but if you want to try at your own risk, query some SQL-commands:

create index joindate on user (joindate)
create index dateline on thread (dateline)
create index dateline on post (dateline)
create index lastactivity on user (lastactivity)

If you don't get what you want, you can undo with:

alter table user drop index joindate
alter table thread drop index dateline
alter table post drop index dateline
alter table user drop index lastactivity

Freddie Bingham

04-11-2002 03:34 PM

Don't add those indeces to your forum as it will result in a general slowdown.

It will make these stats appear instantly but you will then have dateline indexed twice in thread and post since it is part of a multi-record index already. You will then have lastactivity indexed on the user table which will then have to be updated on every pageview which can be a bad thing.

It is important to devote optimization to the user side of the forum at the admin panel's cost.

Harvey

04-11-2002 04:43 PM

huh - did I miss something in the upgrades? I can't find any indices of dateline (checked with show create table post / thread)

But you're right, it would slow down update/insert/delete-statements.

Freddie Bingham

04-11-2002 05:59 PM

Your right. I am getting confused with vb3 tables I think. Just ignore me. I still woudn't put that index on the user.lastactivity though.

Martz

04-12-2002 07:22 AM

Excellent, works well apart from the slow admin/index.php - but that I can handle.

Austin Dea

04-13-2002 05:07 PM

Works bootyfully :D.

All times are GMT. The time now is 09:44 AM.

Page 5 of 12

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01282 seconds Memory Usage 1,737KB 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 (4)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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: