Problem with Image in report and loading speed

[CFPR]

I have a report that needs to display 12 image (jpgs). The image size range from 360k (2 of them) to 64k(10 of them).
The images will change based on the record selection of the report. I have figure out how to add the image doing the following: Insert OLE Obect, From File, Select 'Link' and the select the images.

This works great on my development PC running Windows XP Pro. However, when the report is called from the production environment it becomes EXTREMELYYY slow. The 'Updating ActiveX Object' dialog seems to be frozen specially in a Windows 2000 Professional PC. Loading may take anywhere from 2 to 20 minutes!! Why? Obviously unacceptable.

Any ideas on how to speed up the 'refresh' of the images to be viewed. Also, is there a better way to do this? Please feel free to comment. The image are 'not' part of the db (BLOBS). They are all external residing on disk.

Thanks

MW

 

[synapsevampire]

I'm unfamiliar with this, but make sure that you've applied all of the monthly hotfixes.

-k

 

[chelseatech]

Check your table joins and record counts. Remember the Image is loaded in the recordset for EVERY record. Using a subreport to retrieve the Image can reduce the initial recordset site.

Example
Recordset of 100 records joined to a company record with the company logo (500k) requires 100x500k extra bytes = 50MB of data.

Moving to get the logo in the page header in a subreport reduces that to 1MB in the two page headers (500k x 2 pages)

If you have thousands of records multiply that by your image sizes.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm