Bigger image rendering difficulty using RMagick

I am using RMagick for uploading Pictures of Bigger JPG formats. I am able to render the images properly at my page if the image pixels are below 900x900 pixels, but if the images are bigger lets say when I tried to see the images of 3000x3000 pixels JPG pictures after uploading, only half of the image is coming up. Only Half of the image is coming up for the original and medium_thumbnail view, but for the small_thumbnail is coming up fine.

But I need the bigger jpg with 3000x3000 pixels to be allowed as a mandatory.

Please help and suggest me for my requirements. Thanks in advance. NOTE: I am storing the pictures in 3 columns in MySQl as blob files.

View:

updated one: I am using RMagick for uploading Pictures of Bigger JPG formats. I am able to render the images properly at my page if the image pixels are below 900x900 pixels, but if the images are bigger lets say when I tried to see the images of 3000x3000 pixels JPG pictures after uploading, only half of the image is coming up. Only Half of the image is coming up for the original and medium_thumbnail view, but for the small_thumbnail is coming up fine.

But I need the bigger jpg with 3000x3000 pixels to be allowed as a mandatory.

Please help and suggest me for my requirements. Thanks in advance. NOTE: I am storing the pictures in 3 columns in MySQl as blob files.

View:

updated one: I am using RMagick for uploading Pictures of Bigger JPG formats. I am able to render the images properly at my page if the image pixels are below 900x900 pixels, but if the images are bigger lets say when I tried to see the images of 3000x3000 pixels JPG pictures after uploading, only half of the image is coming up. Only Half of the image is coming up for the original and medium_thumbnail view, but for the small_thumbnail is coming up fine.

But I need the bigger jpg with 3000x3000 pixels to be allowed as a mandatory.

Please help and suggest me for my requirements. Thanks in advance. NOTE: I am storing the pictures in 3 columns in MySQl as blob files.

You're probably hitting a limit either on the amount of data you're
trying to insert into the column (blob columns have a size limit
specified when you create the column) or in the maximum packet size
mysql is using (which is effectively an upper bound on the size of a
query and hence the amount of data you can insert in one go)

Fred

might i suggest storing files on the filesystem? [novel, i know.] if it's a matter of privacy you can use send_file to serve files from folders other than public. there's absolutely nothing gained [as far as i can see] from storing images in the database when the file system is designed for managing files so well. it seems like storing data in flat files on the filesystem or something.

RSL

Its going to be a major change if its going to be a filesystem. I need to do some research on that also as I am new to filesystem manipulation for pictures, if you point me some info on that will be appreciated. But meantime I need to figure out if any changes in the blob size could save thing, it would be great. Only 3000pixels i need and size may lets say 3MB. But still wondering in my previous code if you see, why there is problem in rendering medium_thumbnail as it is already resized to smaller one and stored.

So still wondering is it only Blob size is the culprit or something to do with RMagick. For my goodness I am trying to change to LongBlob and check if its going to do anything with the Blob size.

What do u say?

Cheers, Nish

RSL ___ wrote:

After changing to LongBlob from Blob, I tested for couple of 2400 pixels sample jpeg files, it looks good so far. Thanks Fred for a quick hint. And RSL, if you could give me some info or some links regarding storing in FileSystem and managing my requirements, that will be helpfull. Thanks again Fred and RSL for your valuable info. Cheers.

um... i don't have references for storing files on the file system. sorry. it isn't really something people write articles and blog posts on. it's just the standard way of doing things. [they call it the filesystem for a reason. ;)] feel free to keep on with the leet storing files in database. i was just sharing with you the information that you don't really gain anything from doing so and lose a lot of what the filesystem is good at.

RSL

RSL ___ wrote:

um... i don't have references for storing files on the file system. sorry. it isn't really something people write articles and blog posts on. it's just the standard way of doing things. [they call it the filesystem for a reason. ;)] feel free to keep on with the leet storing files in database. i was just sharing with you the information that you don't really gain anything from doing so and lose a lot of what the filesystem is good at.

RSL

On Mon, Aug 4, 2008 at 3:31 PM, Nishi Asem

Thanks for the info and help RSL. Cheers, Nishi