what is the best way to store image file to database?

[plusnplus]

Hi..,

between:

1. put image file (jpg/ gif only) to mysql db use bolb data type.

2 put the link\ picture location path to mysql db use varchar data type.

 

picture file condition:

1. estimated 1000-1200 images

2. each picture is less then 10 kb, max 800 x 600px

 

which one is best way to store image file to database and why?

 

Thanks for any info/ reply.

 

 

[fenway]

If you don't need to access the images across multiple machines, save yourself the headache and just store a relative pathname.