I currently have an ODBC connection to a SQL server that exists on the other side of the country from me. I'm running queries in Access and I've found that over time, queries run slower and slower. If I create a new database and bring in the same tables, it runs quickly (relatively speaking) again. Why is this happening? Is there something I can do besides creating new databases all the time?
Thank you in advance.Is the problem that over time the query has more and more records to move through? Is the DB normalized?
No comments:
Post a Comment