R
Richard.Kelters
Guest
I'm wondering what the impact is of using a blob field in database table? We have a 'customer' record with a blob field with a picture of the customer. As camera's get better in time we see the picture growing from ten's of kilo bytes to serveral mega bytes. Our application reads the customer record quite often but the picture is rarely needed, only in 2 places in our application. Does an io record read that has a blob need to do an additional io read for the picture? Does the blob field reside in the database memory (-B)? Would it be advisable to put the blob field in a seperate table in our case?
Continue reading...
Continue reading...