Database Issues

• In programming a large operation with lots of file I/O, consider using transactions. BeginTrans and CommitTrans will take better advantage of available RAM than direct disk reads and writes, and will almost always be faster.
• Avoid using the data control.
• Where possible, use pre-compiled queries. In SQL Server, use stored procedures rather than dynamic SQL; in Access or Jet, use QueryDefs with parameters.
• Try to write applications that access one row of data at a time. This is more code-intensive, but has performance advantages: it avoids the memory overhead of arrays or data access objects, and minimizes the aging data problem common to multi-user applications.