ASP-ORACLE-ADODB Performance Issue

Hi All,

I was wondering if any of you could help me with a very difficult problem that I am having.

I have an ASP site that works with an Oracle database using an ADODB connection. This connection is stored in a .dll file. This site had been working fine.

However recently we upgraded our Oracle database from 9i to 10g and ever since then we have been having serious performance problems with this site only.

The website works fine apart from when the user does an update on the database. i.e. the site’s performance is acceptable until the user selects an option that updates the database.

I have isolated the exact line of code (see below) where the performance issue occurs and I was wondering if any one here had a similar issue and whether they could help me resolve it.

Many thanks for any help you can provide.
Colm

Expand|Select|Wrap|Line Numbers

 
<%@ LANGUAGE="VBSCRIPT" %>

<!-- #INCLUDE FILE="pig.asp" -->

<script language="Javascript" src="getoptions.js"></script>

<html>

<%

if (Request.Form("visitpreparationadd") = "visitpreparationadd") then

'**************************

'    Adding a Record

'**************************

    si = Request.Form("site")

    nm = Request.Form("stdate")

    set acom = server.CreateObject("onsite.on_st_sites")

    comStat = acom.visit_preparation(si,nm) 'THIS LINE OF CODE SLOWS THE PERFORMANCE

    set acom = Nothing

'Where there any errors

    comStat = "0"

    if comStat <> "0" then

        displayerror(comStat)

    end if 

    set acom = server.CreateObject("onsite.on_st_sites")

    comStat = acom.list_visits_date(si,nm,"Y")

    set acom = Nothing

    visitpreparation_add_OnSubmit = False    

end if

%>

<head>

<meta NAME="GENERATOR" Content="Microsoft FrontPage 4.0">

<title></title>

</head>

<body background="images/onsite_bck.gif" text="#000000" vlink="#000000" alink="#000000" link="#000000">

<%heading = "Visit Preparation Page"%>

<table width="669" height="143">

    <th width="131" align="left" height="16"><b><img src="images/images/Corporate2.gif" width="133" height="67" align="right"><br>

      <br>

      </b></th>

<th width="524" BGCOLOR="000000" height="1"><font size="3" color="ffffff">

<%if(isempty(Request.querystring("heading"))) then

Response.write(heading)

else 

Response.Write(Request.QueryString("heading"))

end if

%>

</font></th>
 
<tr><td width="131" valign="top" nowrap height="153">

<!-- #INCLUDE FILE="ONSITE_ACCESS.asp" -->

<!-- #INCLUDE FILE="ONSITE_DD.asp" -->

</td>

<td width="524" height="118" rowspan="2">

<%

if (Request.QueryString("visitpreparation_lst") = "yes") then

%>

<a href="test.asp?visitpreparation_add=yes"><img src="images/PrepaerVisits.gif" border="0"></a>

<% end if %>

<%

'---------

'Prepare Visit

'---------

if (Request.QueryString("visitpreparation_add") = "yes") then

    set acom = server.CreateObject("Onsite.on_st_sites")

    set rs = acom.sites_lst_user()%>

    <form name="visitpreparation_add" ACTION="test.asp?visitpreparation_lst=yes" METHOD="POST">

    <table>

    <tr><td>Site</td>          <td><select NAME="site" id="Site">

        <option SELECTED VALUE="NONE">[Please Select a Site]</option>

    <%while not rs.eof

      if rs(0) <> strSite then %>

    <option value="<%=rs(0)%>"><%=rs(1)%></option>

    <%end if

      rs.movenext

      wend%>

      <%set rs = Nothing%>

    </select></td></tr>    

    <tr><td>Date </td>      <td><input type="date" name="stdate" size="10"><img src="ctdatepkon.gif" width="23" height="22" border="0" onClick="popdate('stdate','visitpreparation_add')"></td><td>(example 20-JUL-2001)</td></tr>

    <input type="hidden" name="visitpreparationadd" value="visitpreparationadd">

    <tr><td></td><td><input type="image" src="images/updateblack.gif" border="0" id="image1" name="image1" WIDTH="97" HEIGHT="27"></td></tr>

    </form>
 
<% end if %>
 
<%if (Request.Form("visitpreparationadd") = "visitpreparationadd") then

        Response.Write ("<H1><B>          Processing Completed OK</H1></B>")

end if%>
 
<%function displayerror(errortext)%> 

</td></tr>

</table>

<table>

<tr><td rowspan="2"><img SRC="images/erroricon.gif" ALT="You got an error" WIDTH="96" HEIGHT="192"></td><td><b><%=errortext%></b></td><td width="25%"></td></tr>

</table>

<%Response.end%>

<%end function%>

<script LANGUAGE="vbscript">

function visitpreparation_add_OnSubmit

    Dim frm1

    set frm1 = Document.visitpreparation_add
 
    ChkDesc = "a Site Code"

    set ChkField = frm1.site

    if not IsSelect(ChkField, ChkDesc) then

        visitpreparation_add_OnSubmit = False

        Exit Function

    end if
 
    set ChkField = frm1.stdate

    if not IsFieldaDate(ChkField) then

        visitpreparation_add_OnSubmit = False

        Exit Function

    end if
 
    visitpreparation_add_OnSubmit = True

end function
 
function IsSelect(field, which)

     if (field.value) = "NONE" then

         sMess = "You Must Enter " & which & " - Update Cancelled"

        Alert(sMess)

        field.focus

        IsSelect = False

    else

        IsSelect = True

    end if

end function    
 
function IsFieldaDate(field)

    if Not IsDate(field.value) then

        Alert "Entry must be a date (example 01-Jul-2001) - Update Cancelled"

        field.focus

        IsFieldaDate = False

    else

        IsFieldaDate = True

    end if

end function    

</script>

</body>

Oct 9 '07 #1

Subscribe Post Reply

1465

by: Harry | last post by:

Hi, Can anyone help. I have a asp.net page (c#), with two panels, both of which have asp:textboxes on. When I press the first button, the second panel shows fine. When I press the button in...

ASP.NET

Page Validation and Submit problems in ASP.NET

by: Arun K | last post by:

Hi, I am creating a simple .aspx page to add some fields with validation. I have used different .NET validations like REquiredFieldValidator, RegularExpressionValidator and showed the summary...

ASP.NET

File not Found error on asp page

by: Steve Hoyer | last post by:

I am trying to deploy my first asp.net app to our webserver (2K server, IIS 5) My start page comes up and you can get to the subsequent pages that are tied into our sql server (2K). Each page...

ASP.NET

Data Access with GridView [ASP.Net 2.0] question

by: Robert Smith jr. | last post by:

Hello, Please pardon my newbie question ... I am building an ASP.NET page that displays a recordset with a Delete statement enabled (this all works fine). I want to Insert the current row...

ASP.NET

Populating FormView (asp.net 2.0 using vb.net)

by: sck10 | last post by:

Hello, I am creating a form for users to enter information about a lab and the members of the lab. I have one form (FormView) that they use to enter information about that lab. The keyvalue is...

ASP.NET

ASP.net 2.0 GridView edit mode problems

by: tfsmag | last post by:

I have a Grid that I've set up to have two of the fields use dropdownlists while in edit mode. Now I can bind the data to the dropdownlists just fine. My problem is that the second dropdown depends...

ASP.NET

ASP.NET page bring someones data upon refresh

by: Radx | last post by:

Here in my web application, I have a data entry page with serval controls. Some of the controls have autopostback is set true. But the problem is when two or more people are entering data at the...

ASP.NET

Using ajax in Existing ASP.net Application

by: Mukesh | last post by:

Hi i want to use AJAX.net in my Existing Application I have already installed the ajax .net ..net 3.0 and using VS 2005 in the old application i have added a new web form then script manager...

ASP.NET

ASP Ajax Update Panel

by: AdonisL81 | last post by:

Hello, I am new to .NET I am having trouble with a asp update panel and Gridview. The Gridview control is inside the update panel and I am trying to have the gridview update from a form button....

ASP.NET

How do "update" a field in the <EditItemTemplate> that has a null value in t

by: justice750 | last post by:

Hi All, I am using a FormView control. The allows me to update records in the database. However, when a database field is null I can not update the field on the form. It works fine when the field...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

ASP-ORACLE-ADODB Performance Issue

Similar topics