Another question... Why is it that you feel you need to optimize this? There really isnt any need as far as I can see. The overhead is really small, and will probably go up and down by itself since you have people adding and deleting from the table all the time. If we were talking many MB I could understand you, but a few hundred KB is really silly spending so much time avoiding since it will appear in 5 minutes again when people delete something from your table. Another way to completely remove the overhead is to not let people delete from the table, instead you flag the data as deleted. Gives you larger tables, but no overhead. I guess you have made indexes for your database if you have a lot of select in it, thats far more important than optimizing at the moment. -- -- Kim Steinhaug ---------------------------------------------------------------------- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. ---------------------------------------------------------------------- www.steinhaug.com - www.easywebshop.no - www.webkitpro.com ---------------------------------------------------------------------- "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
