Improve the efficiency of ASP page execution (bottom)

3. Database issues

Design a database structure can greatly improve the speed of the program, of course, how to design the database structure is not the issue discussed in this article. Let's assume we've designed the database structure to see what else can be done to improve the speed of the program.

(1). If your database server and Web server are the same, then it is best to separate. This is sure to improve speed.

(2). If you are accessing the database, it is best not to use dynamic SQL statements, using stored procedures or views.

(3). Sometimes allocating the appropriate database buffers improves the performance of the program. This is because, if you are using an Oracle database, you need to open three sessions for each connection. If you can handle these things well, you will improve the performance of the program.

Summarize

In fact, there are many factors affecting the speed of ASP program execution, the above is only a part. Of course, some of the above techniques are not necessarily suitable for all ASP programs, treat different programs to adopt different strategies. Finally hope that the above article can help you.