Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Double Back End (2K/XP)

    I am setting up a system for recording graves and burials. There are two types of data. The day to day burials and records which include about 65000 records, and is quite large. There is also the static data, prices etc. Will I take a performance hit, if I link the front end to 2 back ends. One with the big table, and one with the more static data. I would like to do this in order that I can be emailed the smaller back end during development, without having to get the whole 25 MEg back end. Meaning there will be FE.MDB linked to BE1.MDB and BE2.MDB.
    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Double Back End (2K/XP)

    As far as I'm aware you will not suffer performance wise. I had to link to many BE's in one app I wrote for no significant performance issue.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Double Back End (2K/XP)

    thanks for the info

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Double Back End (2K/XP)

    I forgot to mention that these BE databases were spread all over a network, as we were doing some timings on them for just that reason.
    Pat

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Double Back End (2K/XP)

    I don't think you will have any performance issues. The only thing I would be careful of is an arbitrary separation of tables such that you lose the ability to enforce referential integrity between tables (you can't maintain RI between tables in different databases).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Double Back End (2K/XP)

    One thing to watch out for that CAN sap performance, particularly with linked databases and a network involved, is subdatasheets and Name AutoCorrect. Name Autocorrect has caused nothing but trouble in the two version of Access it has "graced", so turn it off. Subdatasheets are resource hogs, and you have to turn them off in each table separately or run code (which can be found in the help files on here in the Lounge if you search on "Subdatasheets") to turn it off in all tables. Make sure you turn it off in both front and back end databases as well.
    Charlotte

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Double Back End (2K/XP)

    does that mean that the relationship diagram and all the RI in the front end between the linked tables is irrelevant?

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Double Back End (2K/XP)

    Those diagrams in the frontend aren't irrelevant. They do show the relationships between tables. However, what is shows comes mostly from the backend. You can create relationships in the frontend between linked tables from separate backends, but you CAN'T enforce RI between these tables.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •