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.

wow! nice one :D

EDIT: my mistake... :)

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

Thanks...

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.

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

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

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.

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.

I'll give it a try...

seems to have speed up my forum - thanks!

Great

/me Clicks Install

woow thanx mate ;)

Installed. Seems to work. My site does seem a bit faster. I will update is something happens.

merci super utile :)

Useful time saving addition.
Thanks PitchouneN64ngc

How is this different than the optimize tables function that is in the vBulletin Maintenance > Repair/Optimize Tables admin menu?

Sounds like a great idea, so this will work on it's own ? or can it work as manual ?

From the sounds of it, it makes what you are talking about run on a cron schedule...that's what I'm getting out of this. So you don't have to continually go in and optimize tables...it does it automatically. Which...when I'm away from my site for a few days, this is something that is really nice to have. Or for those that didn't realize that was there or are just very forgetful like I get to run optimize tables :P

I've been looking for something like this. You just made my life easier. Thanks!

Installed and clicked. Thanks.

Merci Pitchoune

nice mod - thanks

It's nice, tiny and sooooooooooooo useful.


thx a lot :)

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

You're right, if your tables crashed when you optimize them manually, my mod can't do that better :)

Work for 3.7 ????

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.

Thanks

Marks installed. Thank you very much!

I'll remove mentionned text from here and posting it in 3.7 Modifications ;)

Thanks for the heads up, Just un installed.

Is there anything like this for vbulletin 3.7.2?

I'll post an update for 3.7 quickly ;)

Thank you :)

when ?

i could really use this in my 3.7, if you have a paypal donate i'll gladly donate to this one.

My mods (including this one) will have updates very soon (testing them for allowing them to work for 3.6 - 3.8 in a package) :)

Nice ;)