Subject | big images in database |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2009-07-17T19:32:24Z |
Hello, I need to store some images in my FB2.1 database. I have a domain:
CREATE DOMAIN IMAGEN AS
BLOB SUB_TYPE 0 SEGMENT SIZE 100;
My question is; Is here any practical problem in storing, let's say, 3Mb images
in blob fields in the database? I ask this because I'm thinking in creating a
special folder inside my app folder, put the images there and in the datase just
save the path to the images. Does it make sense?
The images will be attached to production orders, therefore the table containing
the images will grow with time. It can receive more than 50 orders a day with 3
or 4 images each. Probably this is not too much for a database!! Any comment
will be very appreciated!
-sergio
CREATE DOMAIN IMAGEN AS
BLOB SUB_TYPE 0 SEGMENT SIZE 100;
My question is; Is here any practical problem in storing, let's say, 3Mb images
in blob fields in the database? I ask this because I'm thinking in creating a
special folder inside my app folder, put the images there and in the datase just
save the path to the images. Does it make sense?
The images will be attached to production orders, therefore the table containing
the images will grow with time. It can receive more than 50 orders a day with 3
or 4 images each. Probably this is not too much for a database!! Any comment
will be very appreciated!
-sergio