Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

Searching for a faster way to print datas

edited August 2004 in DADE
Hi,

currently I am printing my datas out of a firebird SQL DB via
IBO_pipeline. Also I am using the data dictionary. There a stored 50
tables and views and near to 4.000 field parameters.
I works, but to slow. Means a report need up to 1 minute to print.
75% is the creating time of the SQL connection.

How can I use the flexibility of the data dictionary, but faster at the
execution?

Best Martin

Comments

  • edited August 2004

    The DataDictionary is used by the Query Tools to configure the
    QueryDataView's TdaSQL object.
    At run-time the TdaSQL object generates sql text that is assigned to the
    database. I do nothink the DataDictionary is used at all for this step.

    Modify your Delphi library path from RBuilder\Lib to RBuilder\Source and try
    running the code using a profiler to see where the bottlenecks are.


    --


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.