title: Best practise for storing image references in database
body: <p>I am developing a website where a single image uploaded to the site may be used by multiple business modules like <strong>Food Item</strong>, <strong>Dish</strong>, <strong>Gallery</strong> or whatever.<br>
  I have a main <strong>image table</strong> that stores references to actual images on the file system.<br>
  Now, each record on this table can be referenced by item, dish or gallery tables.<br>
  My question is, should all these references be stored on a single table or should I maintain a separate table like ItemImage, DishImage?<br>
  Problem with single table is I fear this table will be bombarded with high hits eventually increasing the response time. Problem with multiple tables is I have to keep adding more tables as the module count increase on the business front.<br>
  If I say performance is top priority to my site, whats the best approach?</p>
  
  <p>SQL Server 2012, .Net 4.5, MVC 4. </p>
  
  <p>Thanks</p>