I am newer to Database programming and my question is this:
Is it better (when you expect your access files to be extremely large) to normalize not only tables but maybe place those tables in seperate files? Intuitively it seems so to me that way you can receive queries from multiple users spread out accross a multitude of files rather than bottlenecking it with one huge file.
Is it better (when you expect your access files to be extremely large) to normalize not only tables but maybe place those tables in seperate files? Intuitively it seems so to me that way you can receive queries from multiple users spread out accross a multitude of files rather than bottlenecking it with one huge file.