I have a split database with multiple front ends and one back end. These are all stored on network drives.
When just using it for data entry, all works as it should. However, when running SQL queries, the performance slows right down and what takes 5 to 10 seconds when a single user is using it can take over 40 minutes when we have multiple users.
Can anyone explain why this could happen? I've compressed the FEs and the BE too.