Speed with Macro

  • Thread starter Thread starter alan
  • Start date Start date
A

alan

I built a series of four queries into a macro and ran
them on 100,000 records and it took 6 minutes. I then
ran the same macro (4 queries) on 1,000,000 claims and it
has been running for hours. What is up with that?
Shouldn't it run 60 minutes?
 
"alan" wrote
I built a series of four queries
into a macro and ran them on
100,000 records and it took 6
minutes. I then ran the same
macro (4 queries) on 1,000,000
claims and it has been running for
hours. What is up with that?
Shouldn't it run 60 minutes?
Click to expand...

No, not necessarily. How long it will run depends on a number of factors
and, at best, isn't necessarily a simple straight line projection.

If you'd post a simplified form of the queries, someone might be able to
give you some worthwhile suggestions.

Larry Linson
Microsoft Access MVP
 
Alan,

In my experience, when you're dealing with this order of
magnitude of record count, you'de far better off working
with recordsets through VBA code than running queries
through macros. Chances are you'd end up with a fragment
of the execution time (possibly a small fragment!).

Nikos Y.
 
hello
Alan,

In my experience, when you're dealing with this order of
magnitude of record count, you'de far better off working
with recordsets through VBA code than running queries
through macros. Chances are you'd end up with a fragment
of the execution time (possibly a small fragment!).

Nikos Y.
Click to expand...
 
sdasd
Alan,

In my experience, when you're dealing with this order of
magnitude of record count, you'de far better off working
with recordsets through VBA code than running queries
through macros. Chances are you'd end up with a fragment
of the execution time (possibly a small fragment!).

Nikos Y.
Click to expand...
 
Back
Top