I've created a rather extensive site. (800+ dynamic pages.) When I began creating the site I was a novice at best at ASP. I'm still not an expert, but I've gotten alot better. I'm beginning to go back and do some optimizations on my code now.<BR><BR>One thing I'm trying to do is put SQL statements into stored procedures. Should I do this with all frequently used statements? For instance I have a page that reloads every three minutes. The only SQL statement on the page is a simple select statement? Should I still encapsulate it in a stored procedure?<BR><BR>Can anyone give me some direction? Thanks!