Clean Up Your Objects—In the Right Order

Although Microsoft Internet Information Server (IIS) eventually removes your unused database objects (called garbage collection), poor coding can squander the server’s resources. If your Web server drags or even fails for no apparent reason, look for connections and objects that haven’t been closed. For a high-volume, data-intensive Web site, you can’t wait for IIS to do the job. You must clean up your database objects yourself and do so in the right order: close each Recordset and then set the object to Nothing (Set myobject=Nothing).

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: