Speed with Macro

[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?

 

[Larry Linson]

"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?

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

 

[Nikos Yannacopoulos]

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.

 

[Kimjac]

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.

 

[Kimjac]

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.