Arrrrg! Split DB has become unbearably SLOOOOOOW!

[rafe]

Hope this is a setting issue...

I've just yesterday split my DB into front & back ends with the back end on a shared network folder. Since doing this, the DB has become unbelievably slow! For example: it can take over 15min. (I killed the process) to display a two-page report. I expected some slow down but opening forms can take between 2 to 5 min. the other user has given up on an Access solution.

I've tried:

1) Compact & repair
2) Doing the reasonable solutions to the Analyze (can't reduce # of controls). Also, this utility will hang sometimes.
3) Got a call into the College Network admin. Maybe there are some pointed questions to ask the admin?

Maybe I’ve done something horribly wrong here by splitting the db because it ran quickly.

 

[dneufarth]

If the DB was on a local machine and now is split between a local machine and a server elswhere on the network, sounds like a network speed/capacity issue.

Just because you move the Access back-end to a server, all processing still gets done on the local machine. That means all data must be transferred to/from the server. Considerably slower than data transfer on a local machine.

Dave

 

[RickSpr]

Adding indexes might help, especially on fields you use to join tables or restrict recordsets. Of course, indexes cost you more when adding records (and possibly when updating, if you update indexed fields), so be sparing on tables which have a high ratio of inserts to selects.

Did you design your application with optimistic record locking? That's very important in a multiuser networked application.

How does it perform if the back end is on the workstation? Rick Sprague

 

[rafe]

Rick & Dave

I appreciate your input. Some answers:

1) i'm going back to optimistic locking everywhere i can.

2) i've added indices to just about field i thought it might help.

3) i had to move things back to my work station to get anything done & it flies there ... but of course, only i can use it

4) sounds like the network administrator has got my files on a 286 with a 1200 baud connection to the network... i've never had to kill an Access process for time before (15min is too long)

5) i haven't gone to mde just yet & that might help accoring to the documentation. but the db is still in flux... my new assistant need forms instead of plain tables

of course i'll read up on this but any & all ideas are appreciated. thanks!

I'm going to my happy place now...