Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
Reload this Page Administrative and Maintenance Tools - Optimize Tables
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 4 1 23 Last »
 
Thread Tools
Optimize Tables Details »»
Optimize Tables
Version: 1.0.0, by PitchouneN64ngc (Senior Member) PitchouneN64ngc is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page
Category: Administrative and Maintenance Tools - Version: 3.6.8 Rating:
Released: 10-23-2007 Last Update: 02-14-2008 Installs: 80
Uses Plugins
Additional Files  
No support by the author.

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

[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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 10-24-2007, 07:34 PM
elmati elmati is offline
 
Join Date: Mar 2007
Location: Argentina
Posts: 183
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
wow! nice one

EDIT: my mistake...
Reply With Quote
  #3  
Old 10-24-2007, 07:42 PM
COBRAws's Avatar
COBRAws COBRAws is offline
 
Join Date: Oct 2002
Location: Buenos Aires
Posts: 864
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by elmati View Post
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
Reply With Quote
  #4  
Old 10-24-2007, 07:49 PM
kaptanblack's Avatar
kaptanblack kaptanblack is offline
 
Join Date: Mar 2007
Location: Turkey
Posts: 397
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks...
Reply With Quote
  #5  
Old 10-24-2007, 09:11 PM
PoetJA-1975's Avatar
PoetJA-1975 PoetJA-1975 is offline
 
Join Date: Sep 2006
Location: Meh...
Posts: 1,218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #6  
Old 10-24-2007, 10:12 PM
pspmaster93 pspmaster93 is offline
 
Join Date: Aug 2007
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
cool! nice but can you make one for update counters that will allow you to choose some counters that are automatically updated daily.
Reply With Quote
  #7  
Old 10-24-2007, 10:16 PM
ChurchMedia's Avatar
ChurchMedia ChurchMedia is offline
 
Join Date: Dec 2002
Location: Las Cruces, NM
Posts: 473
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I've been waiting for a hack like this. Thanks!
Reply With Quote
  #8  
Old 10-24-2007, 10:20 PM
ssslippy ssslippy is offline
 
Join Date: Jan 2006
Posts: 877
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
What exactly does this do?
Reply With Quote
  #9  
Old 10-24-2007, 10:34 PM
SuperTaz's Avatar
SuperTaz SuperTaz is offline
 
Join Date: Apr 2007
Location: Pennsylvania
Posts: 744
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by ssslippy View Post
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.
Reply With Quote
  #10  
Old 10-24-2007, 11:26 PM
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
Senior Member
  
Join Date: Aug 2002
Location: France
Posts: 515
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Warden-B- View Post
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.
Reply With Quote
Reply
Page 1 of 4 1 23 Last »

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 01:21 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04277 seconds
  • Memory Usage 2,297KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete