When not to use a media field for images

I am looking for recommendations for when it is appropriate to use media fields to manage images and when one should just use relative paths to files in the local file system. It seems like there may be problems if a content type like say restaurants has images but there are say over 100,000 restaurants in the database. First of all, all of these images appear in the media library, and the images don’t get deleted when their associated content type records are deleted. Does anyone else have experience with creating lots of records with media files “attached”? Would really appreciate any comments about this.

You can use “soft” delete concept. Mark record status “delete” but keep it in database.