Large Access DB Table?
Hi,
I am creating a database driven website, and wondered if someone could help me.
If I have a table with a large file size, stored in the same database as my other tables, will the efficiency of access to my other tables be reduced, because of this table?
If so, would creating a new database, and storing the large table there mean that the access to other tables remains unaffected?
Many Thanks, Matt
Peter J. Boettcher posted this at 01:15 — 4th March 2002.
They have: 812 posts
Joined: Feb 2000
It shouldn't effect the performance, unless that table is part of your query. It should be easy enough to test, just make a copy of your database, rename it to something else, remove the large table and try running your query. Like I said before I don't think it should effect performance.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.