Connect to IBObjects (quickly)

rbuser

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

nicocizik

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