Page Optimizations

Results 1 to 3 of 3

Thread: Page Optimizations

  1. #1
    Join Date
    Dec 1969

    Default Page Optimizations

    I&#039;ve created a rather extensive site. (800+ dynamic pages.) When I began creating the site I was a novice at best at ASP. I&#039;m still not an expert, but I&#039;ve gotten alot better. I&#039;m beginning to go back and do some optimizations on my code now.<BR><BR>One thing I&#039;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!

  2. #2
    Join Date
    Dec 1969

    Default RE: Page Optimizations

    You should do this with ALL your embedded SQL statements. Stored procedures are better then embedding your SQL in ASP, there is no question.

  3. #3
    Join Date
    Dec 1969

    Default performance and organization benefits

    Pure performance benefits are not the only reason to move toward using stored procedures exclusively. In fact you may run many sql statements that perform adequately fast outside of a stored procedure. <BR><BR>You should also consider the organization benefits of having all your sql statements in one place. I won&#039;t try and list them all out but there are some real benefits.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts