The Arcive of vBulletin Modifications Site.

Optimize Tables · **Released**: 10-23-2007

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

-> Mark as Installed <-
and/or
-> Nominate for MOTM <-

First package downloaded 260 times.

elmati · #2 10-24-2007, 06:34 PM

wow! nice one

EDIT: my mistake...

COBRAws · #3 10-24-2007, 06:42 PM

Quote:

Originally Posted by elmati

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 · #4 10-24-2007, 06:49 PM

Thanks...

PoetJA-1975 · #5 10-24-2007, 08: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 · #6 10-24-2007, 09: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 · #7 10-24-2007, 09:16 PM

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

ssslippy · #8 10-24-2007, 09:20 PM

What exactly does this do?

SuperTaz · #9 10-24-2007, 09:34 PM

Quote:

Originally Posted by ssslippy

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 10-24-2007, 10:26 PM

Quote:

Originally Posted by Warden-B-

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.