Hi,
I've set-up a script to upload images to my server then resize and insert a thumbnail image and the original image in one table which has three fields (imgid int,thumimg BLOB, fullimg BLOB) I was then going to store other image information in another table (like name,description,date).
My question is, will this affect the speed of the database or create any performance issues? (max image size is 100k in jpeg format, wouldn't be more that 500 queries a day I expect)
The main reason I want to store them in a db is just because they are easier to keep track of and easier to backup/download from the server.
Thanks,
Matt
I've set-up a script to upload images to my server then resize and insert a thumbnail image and the original image in one table which has three fields (imgid int,thumimg BLOB, fullimg BLOB) I was then going to store other image information in another table (like name,description,date).
My question is, will this affect the speed of the database or create any performance issues? (max image size is 100k in jpeg format, wouldn't be more that 500 queries a day I expect)
The main reason I want to store them in a db is just because they are easier to keep track of and easier to backup/download from the server.
Thanks,
Matt