Hi there,

Now i have a customer which need a system that help keep tract of sales data including a picture, the system need to store a lot of picture in the database (about 500 picture per day). The system is run on PC, after i finish the system, i set a container to let them insert picture, but i found that sometime the picture does not come out or cannot be insert, especially BMP picture. The customer normally using BMP or JPEG picture, so got any way to solve this problem.

Another question is due to the system will store a lot of data with picture, i scare the system will become slow, got any solution?

Regars,

Henry

" i set a container to let them insert picture, but i found that sometime the picture does not come out or cannot be insert, especially BMP picture"

-- what is it that they do when that "sometimes" occurs?

"Another question is due to the system will store a lot of data with picture, i scare the system will become slow, got any solution?"

-- input into container and "[x] Save reference only", the limit is about 2 GB per file.....so continue referencing vs. directly inserting pictures

if u really use 500 images per day then try developing 12 DBs- months of a system where u can store images per month vs. having them all in one datbase!

[MAIN FILE] perhaps a script to detect CurrentTime and Date

|

|-[January]

|

|-[February]

|

|-[March]

....

u get the idea

all the best!

"keep tract of sales data including a picture"

-- well if u keep them as "Invenotry" and referenced u will not have to re-re-create the record...just 'mark it' ( another field with 1-sold or 0-not sold) as sold