ok

ive kinda only recently become aware of the fact i could damage my server

i dont really know much ASP

so could people tell me wot i have to be aware of, when am writing ASP

is it only when connecting to a Database, or is there other ways i can damage the server?

and if there are, how can i aviod it?

any/all advice on how to Not damage the server will be great

thanks!

well, am not tryin to damage it

just tryin to avoid it

so its only when i access the database it can effect the server?

not with like if i dont do a "Dim" for sumfin am using and i get the "undefined" error message?

You can't really damage a server, unless you use the FSO object to delete all the files on the server, but you can effect performance in allot of ways.

Each time you create an object it uses resources, try to reuse things like recordset objects on a page as amuch as apoossible.

Also remember each time you use an object whether to connect to a database, or to send an email, etc. remeber to release the object after use, thuse freeing up server resources that may other wise slow down the ruuning.

Also things like session variables use allot of resouces, so try to avoid these on busy sites.

Things like the path to the databases could be stored in application level veriables, which saves on the amount of variables used within the site.

Each variable you create will use up resources, but these are quite mimimal so don't worry to much about this.

wot do ya mean reuse recordset objects, like connect to a table, then close it, insted of using a diff name for connectin to a different table, use the same name as b4?

also, should i do stuff like close "request.querystrings()" for example

" string = request.querystring("string")

...

string.close
set string = nothing"