ASP Optimization

    [become a Member]  [Member login]  
 
Skip Navigation Links
Home
My MusicExpand My Music
MembersExpand Members
LinksExpand Links
Download Music
.Net Code
ContactExpand Contact
Skip Navigation Links.

ASP Optimization

Skip Navigation LinksHome :: Classic ASP :: perfomance and security

12 Top Tips to optimize you Active Server Pages...
  • Pick only the columns you use
    When opening recordsets, don't automatically use a table name and SELECT *, unless you need all of the columns. Using individual column names means that you can reduce the amount of data being sent to and from the server. Even if you do need all of the columns the best performance will be achieved by naming the columns individually, since the server doesn't have to work out what the column names are.
  • Use views
    Views are a neat way to pick only the columns you need. You can add calculated fields in them. They are easier to understand and they perform more efficiently than SQL because they are pre-compiled.
  • Pick only the records you need
    Why handle a whole table if you only show 20 records at a time? Use Recordset Paging
  • Use stored procedures as much as possible
    A stored procedure is pre-compiled and contains an already worked out execution plan. It will therefore run more quickly than a SQL statement.
  • Use stored procedures for data changes
    This is invariably faster that using the ADO methods on the recordset.
  • Don't create a recordset unless it's required
    When running action queries make sure you add the adExecuteNoRecords option, so that a recordset is not created. You can also use this technique in lookup situations when returning just a single row with one or two fields (ID values for example). In this case a stored procedure and output parameters will be quicker.

    • The rest of this page is hidden, you must be a member to view it

    To become a member and get immediate access to the course please join here Free!

    Already Enrolled? please click here to Login

    Next >> ASP Optimization
top of page
©1996/2010 BennySutton.com
all images © their respective owners
Powered By Buy a business This site uses Thumbshots previews