You could set up a PHP cron job to do this. Regards, Torsten "Ng Hwee Hwee" <hhwee@xxxxxxxxxxx> wrote in message news:016001c430ef$c07b7590$800101df@xxxxxxxxxxx Hi, Is there a way to create a schedule to optimise my MySQL tables automatically? The overhead of some of my tables can reach 355,548 bytes over 3 working days! Please help me! Thanks. Hwee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php