Larry Hotchkiss wrote:
>
> I am developing a site with php, apache and mysql. The database will have
> likely 250k to 500k records at most, but the data will be changing often.
> New records will be constantly added and old ones removed. I am pretty new
> to DB's and was wondering what is the best way to keep the indexes tight
> and clean? How do others handle this type of scenario? Could I run a
> reindex or something from a cron job? Thanks for any input.
The indexes clean themselves. But you need to run OPTIMIZE TABLE once in
a while (every week) in order to give the database the optimization info
it needs.
Check out info about this and other optimization info at
http://www.mysql.com there you can also get info from the mysql mailing
lists which are more appropriate for this kind of questions.
--
Paul K Egell-Johnsen
Utvikler/PR Manager
eZ systems as
http://ez.no/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
