Pictures displaying very slowly

rbuser

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

nicocizik

Hi Bill,

Thanks for re-posting, I somehow lost track of your original.

As a test try removing ReportBuilder from the equation and load the images
directly into TDBImages on a form. You mention that you are using the Long
Binary type, have you tried using the IMAGE type to store the pictures on
your DB?

--
Regards,

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