Page 261 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE
P. 261
Database Management Systems/Managing Database
Notes </head>
<body>
<o1>
<%
Dim recordsettest
Set recordsettest = Server.CreateObject(“ADODB.Recordset’’)
recordsettest.Open “SELECT student-id, name FROM Student
WHERE phone = “ & Request (“phone”) “, Application(“db_conn”)
Do While Not recordsettest.EOF
Response.Write “<li> “& recordsettest (“students-id”) &”
Response.Write “<p> “& recordsettest (“name”) &” </p> </li>
records etest(‘’name)
recordsettest.MoveNext
Loop
If recordsettest.BOF Then
Response.Write “<p>No students data in the database. </p>”
Recordsettest.Close
Notes You can build on more complex queries. You may also refer to more advanced ASP
versions and connections.
14.5 Performance Tuning
Performance tuning is the one area in which the Oracle DBA probably spends most of his or her
time. If you’re a DBA helping developers to tune their SQL, you can improve performance by
suggesting more efficient queries or table- and index-organization schemes. If you’re a production
DBA, you’ll be dealing with user perceptions of a slow database, batch jobs taking longer and
longer to complete, and so on. Performance tuning focuses primarily on writing efficient SQL,
allocating appropriate computing resources, and analyzing wait events and contention in the
system.
254 LOVELY PROFESSIONAL UNIVERSITY
