Blobs in Access

  • Thread starter Thread starter John K.
  • Start date Start date
J

John K.

we have a DB field of type OLE Object. We are storing
bytes of data (blobs).. we are running into the situation
that everytime this field is updated, the DB grows.... I
ran the experiment where I was saving 8,000 bytes to this
field... in a loop of 10,000 times... my database size
grew from 3,500KB to 800,000KB ... and all I did was
iteratively update the same field.... even after doing
a DB commit, the size did not shrink. I did a compact,
and then it shrank back down to around the 3,500KB mark.

This sounds like a MAJOR problem with the field type of
OLE Object ?
 
FYI, in case is a question. No I'm not saving images...
just an array of doubles (via Copymemory process to a
byte array)
 
John K. said:
we have a DB field of type OLE Object. We are storing
bytes of data (blobs).. we are running into the situation
that everytime this field is updated, the DB grows.... I
ran the experiment where I was saving 8,000 bytes to this
field... in a loop of 10,000 times... my database size
grew from 3,500KB to 800,000KB ... and all I did was
iteratively update the same field.... even after doing
a DB commit, the size did not shrink. I did a compact,
and then it shrank back down to around the 3,500KB mark.

This sounds like a MAJOR problem with the field type of
OLE Object ?
Click to expand...

Could be. Do you have all the fixes for MS Access and Jet installed?

Microsoft Access Fixes, Patches and Updates
http://www.granite.ab.ca/access/msfixes.htm

This sounds quite interesting. Do you have a MDB with just this test
code that you can zip and email me? After compacting of course.
<smile>.

I'd like to experiment a bit with the various versions of Access and
Jet.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top