Cross tabs executing sql multiple times

Hi,

I am using crosstab in my application which binds only to one dataset.
I noticed in the log that the same sql has been called 3 times for that crosstab only.

Is it BIRT feature or problem with the log messages?

Find more posts tagged with

Comments

mwilliams

What is your BIRT version?

mas_h

2.2.1

mwilliams

BIRT didn't have the same caching back in 2.2.1 as it does now in the most current version, 2.6.1. If you're not tied to 2.2.1 because of its association with another product, you might try this in a newer version. Even if you're using 2.2.1 because of another application that uses it, you could always use a newer version and just make calls out to BIRT 2.6.1 to display your reports. Let me know.

mas_h

I'm afraid that I could not switch to 2.6 at the moment because of customer requirement.

Just out of curiosity, if it is printed in the log more than once, does it take that many
times to execute it?

mwilliams

If the event shows up in the log file, that event is being ran again. It could be a caching issue of an older version that is causing this. I'm not certain. I believe that crosstabs showed up in version 2.2, so they were very new at that point and probably weren't the most efficient beast on first implementation.