Focus on Popular Objects to Speed up an Access 2007 Database

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.

Office Blogs Comments

Comments: (1) Collapse

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

Comments

Comments: (loading) Collapse