Server | static | performance | page uses a "Static" ASP page to improve the performance of your server
Usually, when you display the information in a database, you use a dynamic page to generate it.
This has no effect on the performance of a small web site or when the size of the database is not large.
But when users have frequent access to a database with a large amount of data, the system is still able to withstand it.
The following describes a "static" ASP technology to solve this problem.
For example, now this has a personnel database, structured as follows:
ID, company Email Phone
The usual approach is as follows:
Contact.asp
<table cellspacing=0 cellpadding=0>
<%
Set query = Getdb.execute ("SELECT * from Contacts ORDER by FirstName, LastName")
Do as not query.eof
Response.Write "<tr><td><a href=" ""
Response.Write "detail.asp?id=" & Query ("id")
Response.Write "" > & Query ("a") & "& Query (" Last ")
Response.Write "</a></td></tr>"
Query.movenext
Loop
Query.close
Set query = Nothing
%>
</table>
Detail.asp
<table cellspacing=0 cellpadding=0>
<%
Set query = GETDB.E xecute ("select * from Contacts where id=" & Request ("id"))
If not query.eof then
Response.Write "<tr>"
&