Re: MySQL compacting
| From: | JJeffman | Date: | Tue, 13 Feb 2001 03:53:03 +0000 |
| Subject: | Re: MySQL compacting | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6561@lists.php.net to get a copy of this message | ||
I'm afraid there is no articles on this matter. You are facing a database
design matter.
Auto-increment primary keys must haven't any meaning other than just be the
primary key and relate one table to another, if you had a function to
"update" the auto-increment field to eliminate the holes that function
should manage tables relationships as well. As you can see it'll be very
difficult to implement and probably slows down the script, imagine check all
related tables !
Although you have holes in the sequence, the order between the reminiscent
records will be the same .
Auto-increment fields should not be exposed to the user.
HTH.
Jayme.
http://www.conex.com.br/jjeffman