vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - Track Guest Visits (https://vborg.vbsupport.ru/showthread.php?t=232182)

Paul M 02-25-2011 08:33 PM

Quote:

Originally Posted by CRDeveloper (Post 2166794)
Hey, I have two tables vbulletin_guestviews and vbulletin_guest that are getting overhead.

What do you mean "getting overhead" ?

Quote:

Originally Posted by CRDeveloper (Post 2166794)
Im not able to repair or optimize those tables anymore.

Why not ?

Quote:

Originally Posted by CRDeveloper (Post 2166794)
I red in other place that those are not vbulletin's defaults and may be added by this mod.

Thats correct, they are added by this mod.

Quote:

Originally Posted by CRDeveloper (Post 2166803)
I was trying to uninstall but I can't...

Same question as above - why not ?

Quote:

Originally Posted by CRDeveloper (Post 2166803)
Will be alright if i delete the tables and then reinstall again???

Yep, you could do that.


Sounds rather like you have a mysql issue. There is nothing special about those tables.

Boofo 02-25-2011 08:35 PM

I just optimized those tables fine without an issue.

Maxi62 03-05-2011 06:08 PM

Can you make this addon as widget?

Paul M 03-05-2011 07:38 PM

Probably not, or at least not the full version - might think about just the main (forumhome) display as a widget version at some point.

Alfa1 03-20-2011 04:30 PM

At what point would it make sense to prune the vb_guest table? I recently started using this addon and already have 100.000 records in that table. Does it matter / affect performance if this table will have millions of records?

Paul M 03-20-2011 09:09 PM

If your mysql is working well then it wont have much effect, its all indexed.

However, have you got the auto clean-up disabled ?

Unless you are using the data for something specific then you dont need to keep more than a couple of days worth.

Alfa1 03-20-2011 09:47 PM

Thanks. I see now. I have the auto-cleanup enabled and the table only has data of guests that just visited. So the table will not grow to millions, unless my site become extremely popular.

mmacrypt 03-21-2011 05:52 PM

Thank you Paul, as usual, another great mod.

OldSchoolDSL 03-21-2011 08:34 PM

Optimizing my community. This included turning off most of anything that shows or tracks who is online.

Un-installed

But for what is is worth, this was a cool mod and Paul M did a good job

naturalparent 03-22-2011 11:29 AM

ok. i give up. ive installed. im sure its great. i want to see the stats....

where are they though?

in admin? client side?


All times are GMT. The time now is 04:48 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01327 seconds
  • Memory Usage 1,733KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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