XRL speed affected by the number of users logged into Opera

jodie

One of our customer's has an XRL report which had previously been taking 5 minutes maximum to run. For the last 6 months it appears that the time it takes is directly affected by the number of users logged into Opera. When 20+ users are logged into Opera the report will take around 3 hours to recalculate. If the users then log out of Opera the report will go back to taking 5 minutes. 

This isn't the only customer to suggest that the number of users in Opera affects how long reports take to run.

Has anyone else seen this before?  

Jodie

colin-avey

I may be stating the obvious, but there is often a marked slow down when the second user opens a file. this due to the way VFP caches data when it can assume single user mode despite opening the files in shared mode. Once the 2nd user opens the file there will be a marked increase in network traffic the impact of which will vary depending on how well Rushmore can optimise the query and the volume of data.



Increased records due to history settings can contribute to the problem.