Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons

Reply
 
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
  #22  
Old 10-25-2007, 03:39 PM
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Posts: 3,832
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've been looking for something like this. You just made my life easier. Thanks!
Reply With Quote
  #23  
Old 10-26-2007, 02:19 PM
PJAmerica PJAmerica is offline
 
Join Date: Mar 2007
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Installed and clicked. Thanks.
Reply With Quote
  #24  
Old 10-26-2007, 05:18 PM
Karline's Avatar
Karline Karline is offline
 
Join Date: Feb 2007
Location: France C?te d'Azur
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Merci Pitchoune
Reply With Quote
  #25  
Old 10-26-2007, 05:25 PM
yoyoyoyo's Avatar
yoyoyoyo yoyoyoyo is offline
 
Join Date: Dec 2004
Location: USA
Posts: 1,612
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nice mod - thanks
Reply With Quote
  #26  
Old 10-26-2007, 05:44 PM
howiulf howiulf is offline
 
Join Date: Jul 2007
Location: Germany, NRW
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's nice, tiny and sooooooooooooo useful.


thx a lot
Reply With Quote
  #27  
Old 11-04-2007, 03:38 PM
maxicep maxicep is offline
 
Join Date: Oct 2006
Location: California
Posts: 288
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

this mod is looking good but i think, it is not useful on big forums.

example:
my post table is 400mb also user table is 40mb.

if i optimize this tables manually in admincp, system crashes 1-2min, and sometimes site down, cause optimize doesnt complete
Reply With Quote
  #28  
Old 11-04-2007, 04:16 PM
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
Senior Member
 
Join Date: Aug 2002
Location: France
Posts: 515
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You're right, if your tables crashed when you optimize them manually, my mod can't do that better
Reply With Quote
  #29  
Old 02-10-2008, 11:07 AM
bollie's Avatar
bollie bollie is offline
 
Join Date: Jun 2006
Location: Zele (Belgium)
Posts: 259
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Work for 3.7 ????
Reply With Quote
  #30  
Old 02-10-2008, 11:36 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I must post a small warning here:

- Optimising/Repairing tables is not something that should be done on a daily/weekly basis. It has not much use and it might even cause table corruption.
- If your tables crash regulary then you should try to find the cause of this and prevent it from happening, not disguish the symptoms by repairing often.

PS Also please remove the Jelsoft copyright and your license-id from the header of the PHP-file.
Reply With Quote
  #31  
Old 02-10-2008, 03:59 PM
1230 1230 is offline
 
Join Date: Jan 2008
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks
Reply With Quote
Reply

Thread Tools

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 03:05 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.06093 seconds
  • Memory Usage 2,293KB
  • Queries Executed 25 (?)
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
  • (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
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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