By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,947 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,947 IT Pros & Developers. It's quick & easy.

Database slowdown if you connect to more than one BE?

100+
P: 365
Just wondered really if connecting to multiple BE's makes the database slower in general? I have a project whereby i want to store information in 5 databases (site Specific) but i want some information to be in a common database.

Thanks for any info.

Dan
Mar 27 '10 #1
Share this Question
Share on Google+
6 Replies


ADezii
Expert 5K+
P: 8,705
Depenidng on the information that you require, why not programmatically Link/Break Links to specific DBs?
Mar 27 '10 #2

100+
P: 365
Yeah i plan to be able to re-link the different databases, but i need one or two tables to be the same for all databases, this information shouldn't change much and should be quite limited in size, the bulk of the information should grow in these 5 seperate databases, just wondered if this would slow things down, the alternative would be to have this information in each database with some kind of syncronisation required (not best practice huh)

data is stored on a WAN by the way....
Mar 29 '10 #3

Alireza355
P: 86
Programatically linking / breaking links to tables seems so interesting. Can you please provide more information? Thanx
Mar 29 '10 #4

100+
P: 365
i do it like this, very simple:
Expand|Select|Wrap|Line Numbers
  1. Function ReMapTable()
  2. Dim tdf As DAO.TableDef
  3.     For Each tdf In CurrentDb.TableDefs
  4.         If Mid$(tdf.Name, 2, 3) <> "Sys" And Left$(tdf.Name, 1) <> "~" Then
  5.             tdf.Connect = ";Database=" &"**Destination**" & "##Database##"
  6.             tdf.RefreshLink
  7.         End If
  8.     Next
  9. End Function
  10.  
that code relinks all tables to a given destination, i also use a function to select my locations, of course the code could be more complex... but i like simples...

Dan
Mar 29 '10 #5

Expert Mod 2.5K+
P: 2,545
Hi. In my experience linking multiple back-end databases does not of itself cause any performance deterioration to the performance of the front-end database. The linked back-end databases do not appear to be accessed by the front end at all until a query referring to tables from that database is executed.

I've seen no evidence so far of any polling or other checking of status of the tables concerned being done when forms etc referring to the linked tables via suitable queries are not open.

I use a reporting front-end system linked permanently to four different back-end systems located in different folders on a network drive with no apparent slow down from the links. Wish I could say the same about the network on which these are located, but that's a different issue!

-Stewart
Mar 29 '10 #6

100+
P: 365
OK, thanks i will give it a whirl, i can see no other way of doing it easily really, i can maybe create temporary tables if it gets too slow.

Thanks
Mar 29 '10 #7

Post your reply

Sign in to post your reply or Sign up for a free account.