I admit I didn't look too hard to see if this has already been discussed...
I find some of my databases running slowly. I am trying to design them better so they run faster and are more user friendly. I have started by changing the character limits and types on most tables. Additionally, I have been having a debate with myself about which would ultimately be faster. Creating more relationships or having fewer relationships and more sub-forms / reports. Obviously there are some relationships that make sense, like phone numbers. However, what about a city or zip code being separate if you may not know that information? It would make it far more complex to break things down in such detail, but it seems like it might run faster also.
Thoughts? Other ideas for making a database faster?