RE: Dealing with auto-increment in MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



[snip]
I was wondering if people is asking this in the belief that the 
autoincrement field is the record position in the database table and
that by 
not reusing those positions, the space of  the deleted records is
wasted. 
Perhaps when they say renumbering what they are meaning is compacting
the 
database reusing the empty slots they assume those autoincrement fields 
point to.  Someone remembers dBaseIII .dbf files?  Well, perhaps that is
the 
picture they have in mind.
[/snip]

Maybe, but it seems as if more of this is about keeping a contiguous
'index' of the records contained in the database. 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux