if file_exists or db column

[justinma]

I have been working on db that holds business listings and the web pages that access them. I have it setup now so that when an new listing is added, if they have a logo, it is renamed with the primary key field in it so it can be found using if file_exists. Is it faster to do it this way, or to add a field to the db to store the image name.
Thanks
Justin

[mistcat]

Its probably better to do it the way you are doing, because if you just pulled the name from the database you'ld probably still want to check if it existed before marching off into the sunset, so its a little bit of a waste to keep the file name in there. That being said, its probably a huge pain in the ass to find logos if they all have names like 343243 or whatever...So maybe it does make sense to keep the name in the database AND append the primary key to it to ensure its a unique name. (i.e. people don't keep sending you logo.jpg).

Hope this helps!
Nate