Performance with linked tables

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Performance with linked tables

    I notice that performance drops when using linked tables in two Access 97
    databases instead of all tables in one database. I.e. the ASP page takes
    longer to load. Can anybody confirm this is normal?


    Eddie Simons Guest

  2. Similar Questions and Discussions

    1. LInked Tables...
      I am getting the wrong id, when I create the link to the details page from the code below. What I get is the Artist #id#, I want the Album #id# ...
    2. Linked SWF loadMovie performance is pathetic
      Hi! I've seen many other users post on this issue, but most do so because they can't get it working. Here's the deal 1.) I'm using Director MX &...
    3. Connecting to linked SQL tables through access
      Hello, I have searched the web and can't find a solution, but this must (maybe) be common. I am creating an asp page that connects to an access...
    4. Updating via Form to linked tables
      I have a set of linked tables (To Oracle DB) that I need to update via a form. Up to now, I have had pretty straightforward forms that basically...
    5. linked server performance
      For SQL Server these row numbers are relatively small. I'm not sure that using CPU usage is saying much in terms of performance unless this is not...
  3. #2

    Default Re: Performance with linked tables

    Eddie Simons wrote:
    > I notice that performance drops when using linked tables in two
    > Access 97 databases instead of all tables in one database. I.e. the
    > ASP page takes longer to load. Can anybody confirm this is normal?
    It sounds pretty normal. You're accessing two files instead of one. Why
    wouldn't it take longer? What kind of performance loss are we talking about
    here?

    Bob Barrows


    Bob Barrows Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139