Even small Image files split into multiple blob parts

Hi, I am having a problem with image sizes and the size of the blobs in the
Aggregate mySQL database.

The images are being split into multiple blob parts which is OK for
Aggregate but a problem with extracting data via a reporting tool.
I am happy to restrict the size of the image file to keep images within a
single blob part.

According to ODK - the image will only be split if the image is larger than
1 MB.

"The database tables are structured so that unbounded-size images can be
stored in the database. If your image size is under 1 MB, it is stored in
one data record, but if you have larger image files (or longer streaming
videos), they are split across multiple blob records, and writing the logic
to reconstruct them will be error-prone."

However, when I submit forms with images that are even 80 KB or less they
are split into 2 blob entries.
Do you have any idea why this might be - is there a setting in a property
file or code within Aggregate that determines these blob file sizes?

Cheers,

Paul.

Yes a bug was discovered and was discussed on the community mailing
list, see last email message on thread for a temporary fix.

http://groups.google.com/group/opendatakit/browse_thread/thread/bb3332f5acfd7861

Hopefully we will have a fix released soon.

Waylon

ยทยทยท On Thu, Jun 28, 2012 at 9:46 AM, Paul wrote: > Hi, I am having a problem with image sizes and the size of the blobs in the > Aggregate mySQL database. > > The images are being split into multiple blob parts which is OK for > Aggregate but a problem with extracting data via a reporting tool. > I am happy to restrict the size of the image file to keep images within a > single blob part. > > According to ODK - the image will only be split if the image is larger than > 1 MB. > > "The database tables are structured so that unbounded-size images can be > stored in the database. If your image size is under 1 MB, it is stored in > one data record, but if you have larger image files (or longer streaming > videos), they are split across multiple blob records, and writing the logic > to reconstruct them will be error-prone." > > However, when I submit forms with images that are even 80 KB or less they > are split into 2 blob entries. > Do you have any idea why this might be - is there a setting in a property > file or code within Aggregate that determines these blob file sizes? > > Cheers, > > Paul. >

OK - thanks very much for responding. Good to know what the problem is.

Best regards,

Paul.