Hi,
I have some VB coding in my report through which I am removing conditions and adding conditions. I was debugging when I realised that removing a condition or adding a condition from the dataprovider is taking around 4-5 mins.
I have a series of statements in which I am counting the number of conditions in a dataprovider and removing the last one. When the remove condition starts executing it executes for nearly 4mins (it does not fetch data since refreshable is false). Also when a condition is being added it takes around 4 mins (it does not fetch data since refreshable is false). And actually when the data is getting fetched it takes less than 2 mins.
The sequence/flow is like this :
- Make all dataproviders Refeshable = false
- Remove the last condition from each dataprovider
- Add conditions to each dataprovider
- Make all dataproviders Refeshable = true
- Refresh datproviders to fetch the data
When I go to view data(Data Manager) I noticed the timings. Each dataprovider is showing 3 different entries with different start times which I think are during the remove condition, add condition and actual refresh.
The first entry shows start time (this I think is when the condition is being removed) 0 rows fetched (this maybe b’cos it is refreshable=false) and 0 secs duration. But the start time for the next dataprovider is only after 4 mins. And same thing is happening for other dataproviders.
Same is the condition for add conditions.
But during the actual refresh the duration is less than 2 mins for each dataprovider and immediately the next dataprovider starts refreshing.
Why is it taking time while adding and removing conditions?
What happens when we add and remove conditions? Does the dataprovider try to purge the existing data or fetch new data?
Akshay
akshay (BOB member since 2004-02-05)