60 Performance and Optimization Tips for your Website - Use stored procedures...
(Page 11 of 12 )
49. Use stored procedures over simple SQL queries.
50. Connection Pooling – ensure connection pooling is enabled by using a DSN (Data Source Name) in the ODBC Data Source Administrator.
IIS
51. Use server side compression software such as Port80’s httpZip (http://www.port80software.com/products/httpzip/)
52. Use GZip compression to reduce bandwidth, but be aware that CPU utilization may go up. A-B testing can help you find the right balance of whether GZip compression is right for your website.
53. Use IIS 6.0, which includes significant performance enhancements such as Kernel Caching.
54. Don’t install or use Microsoft Index Server unless you need it. The cost far outweighs the benefits that Index Server will give.
Next: Don’t enable logging... >>
More Web Development Articles
More By Jase Dow
