By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,995 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,995 IT Pros & Developers. It's quick & easy.

save picture files (.jpg) in database records or save only links to (.jpg)

P: n/a
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.
Jul 19 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
Bunset wrote:
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?


Put links. I find that easier.
Jul 19 '05 #2

P: n/a
Bunset wrote:
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?


Put links. I find that easier.
Jul 19 '05 #3

P: n/a
Bunset wrote:
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?


Put links. I find that easier.
Jul 19 '05 #4

P: n/a

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.


That entirely depends...

....common wisdom is to store the BLOBs in the filesystem, since that was
usually designed more for storing objects than a database. However, if you
have need for security above and beyond what the FS can give you, you might
look at storing the blobs in the db. You should note, though, that a db is
much slower at retreiving a blob than a filesystem is.

Jul 19 '05 #5

P: n/a

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.


That entirely depends...

....common wisdom is to store the BLOBs in the filesystem, since that was
usually designed more for storing objects than a database. However, if you
have need for security above and beyond what the FS can give you, you might
look at storing the blobs in the db. You should note, though, that a db is
much slower at retreiving a blob than a filesystem is.

Jul 19 '05 #6

P: n/a

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.


That entirely depends...

....common wisdom is to store the BLOBs in the filesystem, since that was
usually designed more for storing objects than a database. However, if you
have need for security above and beyond what the FS can give you, you might
look at storing the blobs in the db. You should note, though, that a db is
much slower at retreiving a blob than a filesystem is.

Jul 19 '05 #7

P: n/a
Hullo BunSet -
I agree with 419-killer.
but - 'efficient' is relative term. As is 'better'

Any thing required to put an image into blob requires work, even if you've
got the perfect code
to handle the insert and extract.

As for speed of retrieval ? I am a fan of links in table. But sometimes
client wants complete security on images for a distributed application - and
for me ? that means using blobs.

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
mySql / VFP / MS-SQL

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.

Jul 19 '05 #8

P: n/a
Hullo BunSet -
I agree with 419-killer.
but - 'efficient' is relative term. As is 'better'

Any thing required to put an image into blob requires work, even if you've
got the perfect code
to handle the insert and extract.

As for speed of retrieval ? I am a fan of links in table. But sometimes
client wants complete security on images for a distributed application - and
for me ? that means using blobs.

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
mySql / VFP / MS-SQL

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.

Jul 19 '05 #9

P: n/a
If the files already exist, put in links; why double the storage? If you are
going to do away with the file, what will be the external access
requirements? Also, do you have to be able to download them frequently?

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.

Jul 19 '05 #10

P: n/a
Hullo BunSet -
I agree with 419-killer.
but - 'efficient' is relative term. As is 'better'

Any thing required to put an image into blob requires work, even if you've
got the perfect code
to handle the insert and extract.

As for speed of retrieval ? I am a fan of links in table. But sometimes
client wants complete security on images for a distributed application - and
for me ? that means using blobs.

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
mySql / VFP / MS-SQL

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.

Jul 19 '05 #11

P: n/a
If the files already exist, put in links; why double the storage? If you are
going to do away with the file, what will be the external access
requirements? Also, do you have to be able to download them frequently?

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.

Jul 19 '05 #12

P: n/a
If the files already exist, put in links; why double the storage? If you are
going to do away with the file, what will be the external access
requirements? Also, do you have to be able to download them frequently?

"Bunset" <bu****@hotmail.com> wrote in message
news:1b**************************@posting.google.c om...
i dont know what is more eficient,
What do you think is better, put in pictures physically in records in
database or put in links to pictures in records?
Thank you.

Jul 19 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.