Blob Problem

rbuser

Hi,

I have built a report which needs to be very fast at printing to PDF. So in
order to optimize it I only go to
the database once (before the first report is printed). I bassically return
all the records (can be up to 100,000)
into a TStoredProc and use the filter property to get them as needed.This
seems to be alot quicker than going
to the database on the print of every report. The problem is (i think) that
I am returning a small blob field(2k) with
each of these records and I get a 'Cannot Generate Report' error if I return
more than about 150 records!!
I have tries setting the blobs to cache but doesn't seem to have any affect.

Any Suggestions ?

p.s I am using a SQL Server 2000 db

Regards

Jim.

digitalmetaphors

Try using an in memory dataset, rather than a stored proc, to retrieve your
data locally and optimize report execution.

--
Cheers,

Alexander Kramnik
Digital Metaphors

rbuser

OK thanks, but what's an in memory Dataset ? is it just a normal TTable. I
want to avoid accessing the database more than once.


"Alexander Kramnik (Digital Metaphors)" wrote

rbuser

Hi Jim,

Do a search on the net for KBMemTable component or use the in memory table
from the RX component set.

regards,
Chris Ueberall;

rbuser

Ot use a ClientDataSet retrieving all the data at once.