[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

ACCESS BACKENDS AND PERFORMANCE (access 2010)

Hi All Experts
Does anyone know whether having more back-ends with fewer tables performs slower/faster than say one BIG backend with all tables.

I have a number of systems with approximately 10 front-ends (for different departments/functionality etc) and 10 back-ends and always wondered if 'consolidating' the BEs would increase/decrease performance?

The multiple BE systems seem to perform OK; although they require periodic c&r (usually every 3-6 months )

Ideally this question would be answered by someone who has had similar installations over many years (or is involved in MS Access JET/ACE design and drivers)

cheers
0
COACHMAN99
Asked:
COACHMAN99
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
There is always the potential of more users in the same BE (ie consolidating) having a negative impact on performance.  If each of your 10 FE are connected to their respective BE ... I would leave it alone, unless you have some overwhelming reason for consolidating, possible for reporting purposes, etc.

I currently have 45 FEs connnected 45 BEs, with anywhere from 3 to 120 users in a given db. Where as I could ... do some consolidation (and I may for very similar db functions), at this time I am not making any changes.

mx
0
 
COACHMAN99Author Commented:
Excellent thanks; that corresponds with my observations. (if it aint broke ... :-))
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
I agree with Joe...I'd keep them separate.   There is some consolidation of resources if a user uses more than one of the applications at one time, but if their going against one BE all the time, then forget about it.

Jim.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now