mysql index (semi ot)
| From: | Larry Hotchkiss | Date: | Thu, 11 Jan 2001 14:46:28 +0000 |
| Subject: | mysql index (semi ot) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-34005@lists.php.net to get a copy of this message | ||
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.
---------------------------------
Larry Hotchkiss