By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,903 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,903 IT Pros & Developers. It's quick & easy.

Access Performance question...

P: 55
I have several linked tables, with lots of data in them. I have several queries using all this data, which is slowing down the speed of my database. I tried using the "analyze" function in Access, but because my tables are linked no indexing can occur.

Does anyone have any tips to make my Database run faster?
Feb 13 '08 #1
Share this Question
Share on Google+
1 Reply


jaxjagfan
Expert 100+
P: 254
I have several linked tables, with lots of data in them. I have several queries using all this data, which is slowing down the speed of my database. I tried using the "analyze" function in Access, but because my tables are linked no indexing can occur.

Does anyone have any tips to make my Database run faster?
Minimize the number of table joins in a single query. Several small queries building up to eventual data you want is often faster than one massive query. If the data is analysis data (read only) then you may want to create some temp tables which groups and stores the results of your queries. This make s for a better end user experience as they get their results faster.

I truncate and load data analysis tables every day. Minimal or no linking required. End-Users can create their own queries and not have to know a lot of different tables.
Feb 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.