I've been tackling a performance issue with my FE BE application for some time now and have just noticed a performance pattern that may mean something to someone more experienced than I.
When the user uses the FE application and accesses the BE the speed is terrific.
As soon as another user logs in and access the same BE (different data in the same table for instance) the speed drops dramatically for both users. It doesn't matter which user we try this with which means it's not a problem associated with the users computer.
As soon as the 2nd user closes the application (FE) and leaves only 1 user accessing the BE data - the slow speed continues.
If this same user closes the application and reopens it we get our fast speed back.
For some reason as soon as the BE see another FE user it slows right down and won't speed up until both user quit the application and one of the users reopens it again.
Is there a setting for sharing that i don't know about?
thanks in advance.