Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days

Considering Design

Here are a few tips to consider when designing your components. This will help your components scale better in the Window DNA architecture:

• Call SetComplete as often as you can. This tells MTS that it is free to recycle the component. The sooner MTS can recycle a component, the sooner it can give the component to another user.

• Create database connections as late as possible and release them as soon as possible. Connection pooling is still going on, but you want to help that out even more by limiting your connect time.

• Create references to objects as soon as possible. This has little impact on performance. For example,

  Dim rst AS ADODB.Recordset
  

  creates a reference, but doesn't allocate any resources to the actual object. This ...