Hello,
Our scenario is as follows.
We have a Delphi front end which uses the FIBPlus library to connect to
Firebird. Some users run many reports in groups. And most of the reports in
the groups use a common stored procedure with one set of parameters for each
group of reports generated.
Currently in production these reports run sequentially and the common stored
procedure can take many hours to complete. Potentially it could take up to
[many hours] X # of Reports. So we implemented a Report Cache where the
first report in the group would insert the output of the common stored proc
into this report Cache. Any subsequent report from that group would just
select from the report cache. This significantly decreased the time spent
running these reports.
We are now trying to take this another level and leverage Microsoft
Reporting Services for the report processing.
We are using the .NET Firebird data provider to connect to Firebird from
Microsoft Reporting Services.
Our problem is that when the multiple reports are being run, the first one
would run for a long time, and the output of the report would contain data,
which means that the report cache is populated on the firebird side. But
when the other reports are run, they return back with no results. If I do a
select in IBEXPERT to the report cache for the groups data, I return no
rows, but the first report ran successfully.
By best guess is that Microsoft Reporting Services is running the report and
after the report is run, the transaction is rolled back.
My question, is if there is a way to set on an auto commit feature on the
Firebird .net data provider? I know some data providers use an "auto_commit"
( or some other variation ) to turn on/off the auto commit feature from the
connectionstring?
Regards,
Edward Mendez
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
