| Author |
 Topic  |
|
|
GhorZonia
New Member
Finland
60 Posts |
 Posted - 14 July 2001 : 17:01:33
|
I'm working on a script where people can submit their results into a database. All users must upload a screenshot (about 15kb gif) as proof.
I was thinking, it might be better to insert the pic in binary form into a database field. That way it is easier to add, delete and keep track of all of the pics.
I have heard that inserting and downloading pics and files in binary form from a database uses alot of resources on the server. However, all screenshots are only about 15kb (max size is 20kb) and I expect our users to submit about 10 new results per day. After the screenshots are uploaded, they get viewed quite rarely.
Do you think that inserting the images in binary form in the database slows the server down very much?
Oh, and I'm using shared hosting with Access 2000 as the database. |
|
|
asp_storm
Average Member
USA
787 Posts |
Posted - 14 July 2001 : 17:35:37
|
quote:
I'm working on a script where people can submit their results into a database. All users must upload a screenshot (about 15kb gif) as proof.
I was thinking, it might be better to insert the pic in binary form into a database field. That way it is easier to add, delete and keep track of all of the pics.
I have heard that inserting and downloading pics and files in binary form from a database uses alot of resources on the server. However, all screenshots are only about 15kb (max size is 20kb) and I expect our users to submit about 10 new results per day. After the screenshots are uploaded, they get viewed quite rarely.
Do you think that inserting the images in binary form in the database slows the server down very much?
Oh, and I'm using shared hosting with Access 2000 as the database.
yea, and how would you make the db fields?
[_____-asp_newbie-_____]
(__Webmaster__)
[-Newschoolskiing.com-] |
 |
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 14 July 2001 : 20:35:40
|
quote:
Do you think that inserting the images in binary form in the database slows the server down very much?
Absolutely. Why not just enter the URL of the photo in the DB, this way you can do a search with a minimal burden to the server.
Thanks,
Mo |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 July 2001 : 07:15:45
|
it is very simple to retreive images from a database, and does not use any more server resources than retrieving an equivalent sized memo, however, inserting them using web based tools is more dificult, and generally requires a dll, although it would be possible to do without. You would only generally do this if the data was maintained by a local application rather than across the web, since data input is much easier.
|
|
|
|
GhorZonia
New Member
Finland
60 Posts |
Posted - 15 July 2001 : 07:34:55
|
The server has SA-FileUP installed so inserting the images should be easy.
The reason why I would like to insert the images into the database is that I think it would be easier to add, delete and update records and check if the images exist. It would also be easier to take backups of the application.
What do you guys think? |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 15 July 2001 : 11:30:57
|
quote:
What do you guys think?
Seems OK to me.
Think Pink |
|
|
| |
Topic |
|
Topic Locked
