Focus on Popular Objects to Speed up an Access 2007 Database

Published 28 July 08 10:09 AM

Garry Robinson’s latest article for Database Journal is great look at some of the new 2007 features as well as being helpful is addressing a key user need, performance. He shows how you can use macros, TempVar’s and some VBA to profile your application.

by Ryan McMinn

Comments

# Andrew said on July 29, 2008 11:27 AM:

You know, for an article about speeding up a database, there wasn't much on how to actually do it. There was no discussion on indexing, for one. Lack of intelligent indexing is probably the number one cause of slow database processing. Also, an accurate understanding of how queries function is essential. For example, never use an update query if you can get away with putting the information in a new table entirely. It's orders faster for big databases.

Where's the article for clock-times on these subjects?

New Comments to this post are disabled
Page view tracker