Nissim Lugasy writes:
> Why is it that when I delete records from a table in the database, the size > of the table's MYD file does not get smaller. It's still the original size. > Do I have to flush the table to get the accurate size? OPTIMIZE TABLE is what you want. But doing it after each and every DELETE might be considered overkill, at least if you're not deleting a majority of the rows. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
