I have a split database, with the FEs on each users computer and the BE on a networked server.
When one user is on, the performance is great.
When two users are on, the performance decreases noticeably. What took a fraction of second before with a single user, now takes 1-2 seconds to accomplish when two users are in the database.
Is there something I can do to improve this?
As a side note, when two users are on and one of them closes out of the database, the remaining single user's speed remains the same. That is, slower.
If that last user closes out of the database and then immediately reopens the database, the performance speeds up. Why is this?
When one user is on, the performance is great.
When two users are on, the performance decreases noticeably. What took a fraction of second before with a single user, now takes 1-2 seconds to accomplish when two users are in the database.
Is there something I can do to improve this?
As a side note, when two users are on and one of them closes out of the database, the remaining single user's speed remains the same. That is, slower.
If that last user closes out of the database and then immediately reopens the database, the performance speeds up. Why is this?