[PHP] db design with large amount of data (?)

Hi all, i'm currently busy with db design. Since I have not worked with these amounts of content data I have a few questions. I have 2 tables: a table filled with records about products (currently 2200 records) (tblProducts) The next table is a table with pictures referring to product_ID's.

Re: [PHP] db design with large amount of data (?)

I'm no expert on massive amounts of data, but if you index the field which you are querying by (say you're relating the images to the product via productID), then I'd index the productID field of tblPics. Indexing (to the best of my limited knowledge) speeds up the querying process, and slows