November 23, 2015 at 2:55 pm
Hello,
I work for a fashion designer company. Since the inception they have created styles and till date they have about 2800 style images.
I want to create a catalog using SSRS 2012, in which sales person selects few styles and it creates report or catalog based on selected styles.
So I inserted all the images in the database, all 2800, but when I try to run the report it gives me system.Outofmemoryexceptions., When I run same report with about 100 images in the database it works perfectly fine.
Tried googling answer for system.outofmemoryexception but so far no luck. I know I can filter report even when I filter report it gives me 400 to 500 styles.
Any suggestion any help would be greatly appreciated as I have been trying to figure this out since last 1 week.
Thanks
November 24, 2015 at 9:45 am
How large is each image file? Even if you scale them in reporting services it just uses html attributes or CSS for scaling but doesn't shrink the actual image file. It's attempting to load the entire dataset of 2800 images into memory so it's the report server that will be hitting the OutOfMemory exception.
You could consider making thumbnails the images and using an action so for the user to open the full size version.
**
What might be a more sensible option is to store the images files externally and just keep the attributes and links to the external images in the database.
You can use an external image URL loaded from the database in the SSRS image control. That way you can filter the images easily by attributes but leave the webserver to serve up the images to the user.
This would work a lot faster and avoid the memory pressure SSRS is coming under by trying to load all the images in the dataset to memory.
December 3, 2015 at 5:24 pm
Get me? (11/24/2015)
How large is each image file? Even if you scale them in reporting services it just uses html attributes or CSS for scaling but doesn't shrink the actual image file. It's attempting to load the entire dataset of 2800 images into memory so it's the report server that will be hitting the OutOfMemory exception.You could consider making thumbnails the images and using an action so for the user to open the full size version.
**
What might be a more sensible option is to store the images files externally and just keep the attributes and links to the external images in the database.
You can use an external image URL loaded from the database in the SSRS image control. That way you can filter the images easily by attributes but leave the webserver to serve up the images to the user.
This would work a lot faster and avoid the memory pressure SSRS is coming under by trying to load all the images in the dataset to memory.
Agreed, ideally you can post a icon image in the report and have that image link to the actual full resolution version through a URL. I understand that practically speaking you need to create thumbnail versions of your images and that may be time consuming. Since websites do this as a matter of standard, then I think it is worth the effort.
----------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply