Programming - General

What are the best scripting practices?
These rules have been setup to insure the integrity and readiness of our servers. Failing to follow these rules may result in account suspension and/or termination.

  1. When using looping logic of any kind make sure that your loops actually do something and do not loop forever!
  2. Do not load a large amount of data in to a database and then try to do a "select * from table" and get it all out on one web page.
    (Large meaning thousands of rows.)
  3. Close all database connections when you are done with them on each page.
  4. DO NOT put database connections in Session or Application level variables/objects.
  5. Set all objects you use equal to Nothing when you are done with them. (ie. "SetConn = Nothing" or "Conn = null")
  6. Test your script in your local server first.