Free for All: help me speed up my Access Database

[BruceM]

I'll have to remember that example about the teller machine. Analogies can
be very helpful.

 

[Keith Wilby]

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?

Give it Paula Radcliffe's legs.

Keith.

 

[Marshall Barton]

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?

After all the other comments, about all I can add is that
you might gain some improvement from occasionally compacting
the msb files.

Regardless of how effective any quick fix happens to be,
good design is absolutely crucial.

 

[Larry Linson]

from occasionally compacting the msb files.

Marsh, you slipped up typing this... msb files are supposed to be
_secret_... Microsoft Secret Base files! Now you've let the cat out of the
bag.

Larry

 

[Marshall Barton]

Marsh, you slipped up typing this... msb files are supposed to be
_secret_... Microsoft Secret Base files! Now you've let the cat out of the
bag.

There's only a minor twitch betwixt them,
most folks won't even notice the difference ;-)

 

[Anthony]

again, to everyone, dang! ( i decided not to cuss, so I wont say damn.)
oh, damn.

I mean dang.

 

[aaron.kempf]

I call bullshit on this MDB route; MDB is for babies

I can buy a quad core Xeon today for what.. a grand?

SQL Server has obvious performance benefits

-aaron