I have a database which has entries of indexed html pages. Eventually, this database will hold up to 50K entries. This will eventually become a site search function for my site.

At this size, is the size of each entry a concern? Is there an optimal size limit for each entry, which will allow mysql and php to run the fastest, yet allow me to have the highest number of entries before it starts effecting the speed of the application?

Thanks in advance for your help.

Frank

I don't think the size will be a problem, but for a smooth running table you want to make sure you you create indexes properly.

Regarding "creating indexes properly", what are some common mistakes made? When you say "indexes", are you referring to what the spider does, or what the sql database does when it processes information?

Frank

When I talk about indexes, I mean the mySQL table index. The index is a unique table structure that indexes the the related field data. An index can be normal, primary, unique, or fulltext. When you submit a sql query, it checks if there is an index to spped up search results.