hardware

W

William Benson

I have a 2GHz centrino laptop w/ 1GB RAM and when running a query which use
a lot of calculations including DAvg and DStDev but which had a minimum of
dependencies on other queries, it took over an hour. I am ready to give up
the laptop as a development machine, but looking for advice. Today's
technologies are over my head. I just want to know what will seriously
benefit an Access databse. Is this a question that can be answered simply?
What is a dream workstation for an impatient access developer?

Thanks.
 
C

Craig Alexander Morrison

Break the SQL down into stages rather than one big query, if you can. Try
not to use the Domain functions DWhatEver use the Avg and StDev options in
the Totals row of the query builder.

I would suggest you ask the question in the Queries section and post the SQL
you are attempting.

You can bring down a supercomputer if you ask it a question that is
extremely complex to answer.

BTW If you are using VBA with recordsets and all that stuff, forget it and
use saved queries.
 
B

Brendan Reynolds

As Craig indicates elsewhere in this thread, William, the problem most
likely lies with the query and not with the hardware at all - the hardware
sounds perfectly adequate - assuming you have plenty of disk space available
for the paging file and temp files?

In addition to Craig's good advice, check your indexes. Appropriate indexes
can make a dramatic difference to the performance of a select query -
assuming, of course, that the query is designed to make use of the indexes.

As Craig suggests, if you post the SQL, someone may be able to offer more
detailed suggestions.
 
Top