Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Q&A
| Q1: | My script is terribly slow; how can I find out which part of the script needs to be improved? |
| A1: | Use the ASP Profiler Component to measure the time needed to execute the separate parts of your script. |
| Q2: | I want to write a big ASP application for a high-load, database-driven Web site. Because I want to use SQL Server as the database server, will it will pay off to learn T-SQL to implement major database queries and database tasks as stored procedures? |
| A2: | I strongly recommend you use stored procedures for a high-load, database-driven Web site because performance is sped up and database access can be standardized using the stored procedures as the interface for database access. Besides performance advantages, this also provides maintenance advantages. |
