vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - Optimize Tables (https://vborg.vbsupport.ru/showthread.php?t=161028)

PitchouneN64ngc 10-23-2007 10:00 PM

Optimize Tables
 
Description

With this mod, you can optimize all tables with data free automatically.

This is configured in a daily task by default, you can change this if you want :)

Enjoy ;)

[hr]grey[/hr]
Installation

Time: 1 minute
vB version: 3.6.0 to 3.6.x.

[hr]grey[/hr]
Instructions

Import the product and uplaod the given file.

[hr]grey[/hr]
FAQ

No FAQ for now :p

[hr]grey[/hr]
Copyright

All code present is this mod can't be redistributed or anything else without my consentement.

[hr]grey[/hr]
Changelog

- 1.0.0 : Intial release. (October 24 2007)

[hr]grey[/hr]
If you like it...


First package downloaded 260 times.

elmati 10-24-2007 07:34 PM

wow! nice one :D

EDIT: my mistake... :)

COBRAws 10-24-2007 07:42 PM

Quote:

Originally Posted by elmati (Post 1367699)
wow! nice one :)
do u have a demo to inspect the code?

ty for this

There is no demo of this, as it's just a background process. Download the zipped file to check it out ;)

kaptanblack 10-24-2007 07:49 PM

Thanks...

PoetJA-1975 10-24-2007 09:11 PM

hmmm - sounds interesting -but I'm not quite sure what this modification does... Can you explain the process in detail please? And what exactly do you mean by "optimize tables"?

Thanx,

Jacquii.

pspmaster93 10-24-2007 10:12 PM

cool! nice but can you make one for update counters that will allow you to choose some counters that are automatically updated daily.

ChurchMedia 10-24-2007 10:16 PM

I've been waiting for a hack like this. Thanks!

ssslippy 10-24-2007 10:20 PM

What exactly does this do?

SuperTaz 10-24-2007 10:34 PM

Quote:

Originally Posted by ssslippy (Post 1367865)
What exactly does this do?

I think it is kind of like defragging your PC to make it run faster. Same principle. You would be, in this case, optimizing the tables so that your database, and maybe your site, will run more smoothly. That is what I am getting out of the authors description. I could be wrong though.

PitchouneN64ngc 10-24-2007 11:26 PM

Quote:

Originally Posted by Warden-B- (Post 1367876)
I think it is kind of like defragging your PC to make it run faster. Same principle. You would be, in this case, optimizing the tables so that your database, and maybe your site, will run more smoothly. That is what I am getting out of the authors description. I could be wrong though.

It's that :)

Non-optimized tables can have some space which can be released for any other data, and MySQL didn't have this type of process by default.


All times are GMT. The time now is 10:27 AM.

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.02479 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
  • (3)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
  • (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