> From: "Hal Kaplan" <[EMAIL PROTECTED]> > > Seems to me that the real impact would be based on what the DB server > does when you "touch" a record. Are the blobs going to be buffered > automatically or will some other event trigger the IO?
Those data bytes are coming down the wire when I ask for the blob column. Otherwise the db just knows they are there but never really does anything with them. In my case they were jpg format and we needed to put them into a crystal report for one request. Researchers were watching the growth size of the tumor over time. All of these images were "altered" in that a scale measuring ruler was added so anyone could see the size. The image was in a sub report just to keep it as simple as possible. > And I am with you on the backups, Steve. Diffs are usually more of a > headache than they are worth. I would run a full every day if it's > feasible. Diffs rock in db backups! Diffs suck dog balls in file server backups. At least when I had to manage them :) It's been almost 10 years since I had to deal with them for a clients need. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
