M
mopfer
Guest
Thanks Tom and Rob for your responses. You're definitely right that we don't get a chance to restructure very often, which is one reason the question came up. If it's going to be 10 years before we get another chance to do this we want to err on the side of more areas than we truly need rather than fewer. We haven't had any difficulty finding tables and indexes that we are sure we need to separate. And we do have a number of tables we are sure will never be big enough or active enough to require their own areas. When we start looking at tables that don't need a separate area now but would if the company using the database had twice as many users as it currently does, that is the main driver of the "can we future-proof our structure better than we did last time we got to dump-and-load" question.
Continue reading...
Continue reading...