Make your site faster by 89,99% faster.

[morency]

you tested and get a 89.99% better result ?
Is just a question ...

I also optimize db table when I log in to panel.

You can add a httpd restart every 3-5 days (I dont know if is ok:D)

[subzero]

Thats right this can be used for any site

Also note this does it in a hour time so your tables of more or less

users online | hours / mins / days

1 to 10 = day
1 to 60 = once a day
1 to 100 = 1 hour base
1 to 1000 = 1 min base

So basic your site always OPTIMIZE TABLE it self

[khan]

yep.... Gooood. I personally dnt like lava. Not only for lava users, it will work for those who hv lotsa table in their db.
Gonna use it to my next site

[subzero]

This will do it for you as far lavalair using alot of cpu as for mysql and owners are fooking lazy to OPTIMIZE TABLE THERE SITE to make it run smoothly and best

Get corn job to do it for you lol

You need to select all in phpmyadmin then OPTIMIZE TABLE it copy your OPTIMIZE TABLE `user thing in phpmyadmin will auto give this code then add it how i show you.

Now when corn job OPTIMIZE TABLE your table it will do it to all tables and make your site run faster.

Also it does not hurt to add your email to get updates on corn jobs

Got the idea now ?

[khan]

what will happen if normally opt in every query shot?

[subzero]

Add file called opt.php

to www folder

add All your database like

<?php
include("your_config.php");
include("your_core.php");

mysql_query("OPTIMIZE TABLE `users`,`forums`,`chat`") or die("ERROR: DATABASE NOT IN THIS FILE!");

?>

In order
Minute Hour Day Month Weekday
0 * * * *

Now the Command
Corn Job
/usr/local/bin/php /home/USERNAME/public_html/opt.php>/dev/null

Only Change is in red USERNAME to your cpanel username...

Enjoy