Maybe if you ran the delete query, then the optimize table query immed
after, it wouldn't take such a long time.. I would imagine if you had quite
large tables though, it could still take some time.. And if users are
connecting over the internet, you don't want too may delays..

If the user doesn't need any specific feedback about the delete command, you
could do a low priority delete.. That's sketchy at best though from what I
could gather in the manual and around. It just queues the query until the
database is done with everything but it sounds like it might release the
user/client to go on with what they're doing..

You might also check into truncate.. The mysql manual talks about it
briefly.. I guess it's an Oracle thing that mysql supports.. It sounds like
it would keep things clean but sounds slow possibly..



"Jennifer Downey" <[EMAIL PROTECTED]> wrote in message
> Hi all,
> I'm not sure if my first post showed up so I am going to post it again and
> apologize if it shows up twice.
> Is there a way to delete a record from a mysql table without fragmenting
> 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 (
> Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to