Geek Answers Handbook

Low MS-Access Request

I have a query that retrieves information from a single table. This table is quite large at 1.8 million rows and is growing weekly. The task takes a lot of time, and the problem arises when pulling several times. Is there any process that can speed up a query in a database with this set or multiple rows. I have another one with a size of about 5 million lines ... The query is quite simple, using a prompt to print strings related to the site number, and a prompt between dates.

Arrival_ID criteria = [Select Arrival ID] Week criteria = Between[Select week begin:] And [Select week end:]

Any help or direction is appreciated.

+4
source share
2 answers

Indexes in the Arrival_ID and Week columns can help.

If you do not select many columns from a very wide table, you should get pretty fast performance from Access at 1.8 million rows if your indexes are selective.

+5
source

I agree with Kieren Johnstone - can you store data in SQL and then use access to run queries?

Check indexes twice.

When you are compact / repair - do it twice - make it a habit. The second time clears all problems postponed from the first.

-2
source

More articles:


All Articles