Picture - Put the image in the cube or use a URL?

I am working on a report for a client which is running from a Jet cube based on Inventory items.  The cube includes a URL pointing to a picture file for each item.  The images are held in a separate location.

When running the report, it appears that a majority of the report run time seems to be devoted to pulling in the images from the URL.  

From a report performance perspective, would it be more efficient to load the images directly into the cubes and bypass the URL altogether?  My guess is yes, but I am wondering if there are other downsides that I need to consider (both from a cube and report perspective).  

Any suggestions?


Please sign in to leave a comment.