Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: table overhead

  1. #1
    New Coder
    Join Date
    Sep 2002
    Location
    PA
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    table overhead

    i read that table overhead happens when you delete or update a lot of information; i do this regularly; are my tables made bad or do i just need to optimize my table frequently

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Location
    Ontario, Canada
    Posts
    183
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Here's what I've done:

    function optimize ($what){
    mysql_query ("OPTIMIZE TABLE $what");
    }

    Then after I've done all my delete queries, I run optimize ("tableName");

    Offtone.com - In the works...


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •