Slow performance => Seect Query

Resolved · Urgent Priority · Version 2007

Thu 17 Feb 2011, 08:29 Delegate Salima said...

Salima has attended:
Access Intermediate course
Excel VBA Intro Intermediate course

Slow performance => Seect Query

Hello,

I am currently trying to run a query with a DSUM function and a Subtract function, this has resulted in very slow performance as there are currently approximatelty 6000 data entries. Can you advise how best to optimise performance, I think I may have read somewhere that this should be done via a form as generally calculations within a select query are deemed to be malpractice.

I look forward to your responce.

Many Thanks
Salima

Tue 22 Feb 2011, 10:04 Trainer Mark said...

RE: Slow performance => Seect Query

Hello Salima,

Thank you for your question regarding Access query.

There are many options available to optimize slow queries, the idea of a form will not necessarily solve this, most optimisation will require good knowledge of SQL. However, you could try only including data columns that are essential, and also try running the Optimizer in Access. From the Database tools ribbon in 2007, under the section called Analyze, select the Analyze Performance option.
From the dialog box, select queries, and tick the queries to check. Access will make suggestions on how to optimize for best performance.
This may help in speeding up the query.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Mon 28 Feb 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.