In this section, I'll talk about some specific ways to optimize your Windows DNA applications. Check out some helpful optimization hints, such as implementing user or system DSNs instead of file DSNs, avoiding Registry access, using just-in-time (JIT) activation, and a host of other tips that will enhance the performance of your DNA applications.
Implement User or System DSN Instead of File DSN
As mentioned earlier, a User or System DSN gives better performance than a File DSN. That's because a File DSN requires more resources, including RAM and CPU cycles. In Microsoft's DNA Performance Kit, the documentation contains a graph showing the results when changing from a File DSN to a System DSN. The performance in its example ...