ASP-ORACLE-ADODB Performance Issue

1 New Member

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 Reply

1483

Similar topics

1887

Email From Forms with asp:panel.(s) Only one panel works?

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 the second panel, it triggers the script to send the form details by email.

ASP.NET

2604

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 in the bulleted list on top. I have 3 text boxes, and two RadioButtonList. and 3 buttons. One for Submit, Reset and Exit. If submit is pressed page should be validated and submit (insert into

ASP.NET

2701

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 has a datagrid that loads up just fine, but when I click on any link that updates the page, i.e. a column header to sort the database, it returns a 404 error. Any ideas why it works the for the inital load and not on a postback?

ASP.NET

6551

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 *that is going to be deleted* into another table, before the original data is deleted. I am trying to use the RowDeleting method to call an Update or Insert

ASP.NET

6044

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 "LabLocation_ID". With an existing lab, they then need to add the members for that lab. So, what I am trying to do is the following. With the FormView of the Lab open, the user will click a button to open a FormView (InsertMode) and add a new...

ASP.NET

7074

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 on the first dropdown to pass a parameter to it. If I have a selectedvalue set to the second drop down, when i select a new value from the first drop down it gives me this error. "Databinding methods such as Eval(), XPath(), and Bind() can...

ASP.NET

2198

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 same time, in the middle of my data entry , it is brining someelse data on my screen. I look everywhere i could not find the solution. Please help me Radx

ASP.NET

3095

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 and then update panel and some control in it to test it. When i run the programme ir does not work . imean ajax does not works

ASP.NET

1329

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. The form updates the database from which the gridview pulls data. The panel and gridview works if I do a postback from within the gridview such as sorting. but I can not get it to work from the

ASP.NET

2907

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 is not a null value. I am not using any code behind (C#) to bind the data or manipulate the data. I have read that when there is a null value in the database that there is no record in the "dataset". Can anyone show me how to bind a value in the...

ASP.NET

9643

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10147

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9946

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8968

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7494

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6737

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5379

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3645

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2877

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General