Hi there,
I've been looking at my database via phpadmin and have found that there is a section called space useage and from time to time a row appears called overhead. I can use optimize to get rid of it, but what causes this "overhead?" What is this anyway? it doesn't sound like a good thing, and I assume it affects performance on some level.
I've been developing new scripts and adding new tables, and I notice the overhead appears when I delete items from the database, but I have no idea how to stop it from producing overhead and I can't find documentation on this anywhere.
I'm using this code to delete:
my $sth = $custdb->delete ({'Username' => $user},$cond,$acond3);
There are two tables which connect on a key called
CustomerID which is found in $cond.
thanks in advance for any thoughts and tips you can provide.
peace.
I've been looking at my database via phpadmin and have found that there is a section called space useage and from time to time a row appears called overhead. I can use optimize to get rid of it, but what causes this "overhead?" What is this anyway? it doesn't sound like a good thing, and I assume it affects performance on some level.
I've been developing new scripts and adding new tables, and I notice the overhead appears when I delete items from the database, but I have no idea how to stop it from producing overhead and I can't find documentation on this anywhere.
I'm using this code to delete:
my $sth = $custdb->delete ({'Username' => $user},$cond,$acond3);
There are two tables which connect on a key called
CustomerID which is found in $cond.
thanks in advance for any thoughts and tips you can provide.
peace.