optimise for speed? 1

[AlexmacG]

There are several threads with content on a simlar theme of how to increase performance,

Does anyone have any ground rules or guidance?

Such question as the following might arise:

It is presumable quicker generally to work on a PC's hard drive than work accross a network with the same PC?

Is it better to have a complicated query or a series of simpler linked queries?

Is SQL on a server faster than VBA instanciating objects or just using access queries or running SQL code from VBA.

If working on one table is it better to minimise the number of queries/code/macros to do as much work as possible on the single (or set of linked) tables to minimise communication transfer time.

Filtering seems faster than selecting in query. I've noticed that SQL WHERE clause is faster than HAVING according to at least one thread. can anyboidy explain in simple terms please?

 

[lespaul]

I've noticed that SQL WHERE clause is faster than HAVING according to at least one thread. can anyboidy explain in simple terms please?

Here's an article that explains the differences between the WHERE and HAVING clauses.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[AlexmacG]

Thanks Leslie
Useful wee site!