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

Connect to IBObjects (quickly)

edited February 2011 in Datapipelines
We have just upgraded our development software to the latest and
greatest and are running into some appalling speed issues with report
builder. We are using firebird 1.5 and IBO. Opening the folders table
via query "Select * from RB_Folder" takes 6-8 seconds with TIBOQuery and
is instantaneous with TIB_Query. It also takes the data dictionary
nearly 10 seconds to open. This has made our clients very upset. I can
find no way however to connect a TIB_Query to a TppDBPipeline. I was
expecting a speed increase when going from using the BDE to using
IBObjects, but it has only slowed things down. Opening the report
explorer used to take a second or two, and now takes 15-20 seconds...
Any help would be greatly appreciated!

Thanks All,
Branden

--
Regards,
Branden Johnson
Integrity Software Design

Comments

  • edited February 2011
    Hi Branden,

    This is not a known issue. Which version of ReportBuilder are you using?
    Are you able to run the end-user IBO demo successfully (altered for
    Firebird)? If you remove ReportBuilder from the equation and directly
    access the IBO datasets, does the access time decrease?

    Connecting a TIB_Query to a DBPipeline is the same as connecting any
    TDataSet descendent. See the IBExpress demo located in the \Demos\4.
    EndUser Databases\InterBase\3. IB Express\... directory for an example.



    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.