What exactly does it mean when a table becomes fragmented? How do you know when it's happened and something should be done? All the docs and books talk about how bad it is but I'm still confused on what this is and when it happens.
Thanks, -Lisi At 05:00 PM 4/14/02 -0700, Jennifer Downey wrote: >Hi all, > >Is there a way to delete a record from a mysql table without fragmenting the >db? > >Here is the query I am using and it does a horrible job. Fragment city. > > >---------------------------------------------------------------------------- >---- > > >if ($quantity == 0) > { > $gone = mysql_query("DELETE FROM {$config["prefix"]}_my_items WHERE >uid={$session["uid"]} AND id = '$item'"); > } > > >---------------------------------------------------------------------------- >---- > > > >Thanks >Jennifer > >-- >The sleeper has awaken > > >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002 > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php