Access Database Performance

Presenter: Philipp Stiefel.

Query performance is a critical aspect of most database applications. Nevertheless, performance problems are often only addressed as an afterthought to application development when it is more difficult and labor-intensive to fix those issues.

Philipp will present fundamental aspects of database performance and will discuss some simple performance tuning rules that are basically applicable everywhere. These rules already have a huge effect with plain Microsoft Access applications. The effect will be magnified when applied to Access applications with SQL Server backends linked via ODBC.