Re: mysql index (semi ot)

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/