Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Custom report with pictures very slow

rbuserrbuser
edited January 2009 in End User
D7.1 ASA 9.02 RB 10.08

I have a DB with tools in one table and another table with tool pictures
joined by the tool ID. Approximately 150 tools with pictures of about
150kb-300kb. To print a custom report with a simple single line listing
with picture takes from 5 to 8 minutes.

Any ideas on how to speed this up or restructure it for faster response. I
had the picture as a column in the tool table but that made accessing the
tool table very slow. I solved that by putting the picture in a separate
table and reading it after scrolling down a row in the tool table. I need a
solution that end users can implement with the custom designer.

Thanks,
--
Bill Skelton

Landmark Data Systems, Inc.
Two Old River Place, Suite L
Jackson, MS 39202-3435
601-362-0303

Comments

  • nicociziknicocizik
    edited January 2009
    Hi Bill,

    How are you linking your datasets? If you create a simple minimal report,
    connect it to the image table and try to display each image, do you still
    get slow access? Does the slow-down only occur when printing to the printer
    or is is apparent when previewing or exporting to file (PDF) as well?

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited January 2009
    Good morning Nico,

    The SQL code created is...

    SELECT ToolList.classid, ToolList.description,
    ToolList.toolid, sttoolpix.pix
    FROM ToolList ToolList, sttoolpix sttoolpix
    WHERE (sttoolpix.conum = ToolList.conum)
    AND (sttoolpix.toolid = ToolList.toolid)

    Creating a simple report from the pix ONLY table (toolid,pix) and previewing
    the data, its very slow as well.

    The slowness is also evident when previewing the report.

    The Pix's are 922k in size. In the program (Delphi 7.1) locating the tool
    picture after each scroll works fine. Doing a "select * from sttoolpix" in
    ASA 9.02's interactive SQL displays rapidly (of course the pix's are not
    displayed). The ASA data type is Long Binary. If I do a simple joined
    report without the pix, speed is ok. When I add the pix to the query result
    set, it gets so slow I have to cancel the program.

    It feels like there is some very slow conversion of the data from the DB
    (long binary) into the RB Blob type.

    Bill


This discussion has been closed.