Hi everybody,
I've created fairly complex database at work here in the US to manage and track a large amount of projects, reports, and data. Initially this was only used at our corporate office, but a need has arisen for users to access this database remotely from Europe. In total, only 15 people use this database spread across the US and EU.
Initially, performance was great here in the states, but our European users saw very slow performance. I split the database and store the backend on the network now and have users copy the front end to their desktops. This increased performance significantly for a short time.
Unfortunately, performance for our European users is slowly degrading back to a state they consider unusable. I'm looking for ideas to improve the speed.
My first questions to users with slow performance entirely focused on finding what versions of Windows, Office, and Outlook they are running. Everybody shares the same versions, so I'm not sure this is the root cause.
I found this link describing how to help improve split db performance. I wanted to ping you guys here first because you've always been incredibly helpful for me.
Any glaringly obvious things you would check before implementing significant design changes? Just looking for ideas for where to start troubleshooting to find the cause.
I've created fairly complex database at work here in the US to manage and track a large amount of projects, reports, and data. Initially this was only used at our corporate office, but a need has arisen for users to access this database remotely from Europe. In total, only 15 people use this database spread across the US and EU.
Initially, performance was great here in the states, but our European users saw very slow performance. I split the database and store the backend on the network now and have users copy the front end to their desktops. This increased performance significantly for a short time.
Unfortunately, performance for our European users is slowly degrading back to a state they consider unusable. I'm looking for ideas to improve the speed.
My first questions to users with slow performance entirely focused on finding what versions of Windows, Office, and Outlook they are running. Everybody shares the same versions, so I'm not sure this is the root cause.
I found this link describing how to help improve split db performance. I wanted to ping you guys here first because you've always been incredibly helpful for me.
Any glaringly obvious things you would check before implementing significant design changes? Just looking for ideas for where to start troubleshooting to find the cause.