How would an image filed effect performace

[AppDev76]

Hi,
if designing a web application, would it make a differnce if an image field is in a table or the image field is saved in another table with a one-to-one relation.
The assumption is that we won't be doing a "SELECT *"

Thanks

 

[LloydDobler]

I've read many similar posts regarding image field, and it seems that the majority don't reccomend storing the image, but storing a link to the image, as the image will affect performance, increase size dramtically, keep record locks longer, etc. Do a keyword search on 'image' in either this forum, or the SQL programming forum, for all related posts.

Be quiet Brain, or I'll stab you with a Q-tip! (Homer Simpson)

 

[AppDev76]

Thanks