Concurrent Connection From ASP

<i><b>Originally posted by : Velayutham (s_velu@usa.net)</b></i><br />Hi,<br /><br /><br />We are developing a banking project.<br /><br />We are having two applications one is Client Server which is developed in <br />Power Builder and the other is Browser based interface developed in the ASP.<br /><br /><br />We are having a report in which we are running a long query which is taking <br />about 4 minutes in the SQL PLUS.(We are having this report in both the Browser based and<br />the PB)<br /><br />If we run the report in PB, there is no problem i.e all the people who are using<br />the browser are able to make the connection properly.<br /><br />If we run the report in BROWSER, there is problem. i.e none of the people where able <br />to get the connection at all to the database and the browser hangs.<br /><br /><br />IIS is working properly.<br /><br />Is there is any solution for this problem.<br /><br /><br />We are running the following query <br />==================================<br /><br />We are using the below query in both PB and ASP<br /><br />sqlstmt : <br />=========<br />This query is for displaying the address of the client<br /><br />Select <br />Address1,Address2,Address3,Address4,Zip,Phone1,Fax <br />From <br />Branch,Address <br />Where <br />Branch.Address_id = Address.id And Branch.id = 1<br /><br />sqlstmt1 : <br />==========<br />This query is for displaying the holder details <br /><br /><br />Select <br />Client.First_Holder_name, <br />Client.Second_Holder_name, <br />Client.Third_Holder_Name,Address.Address1, Address.Address2,Address.Address3,Address.Address4 ,Address.zip <br />From <br />Client,Address <br />Where Client.Address_id = Address.id And <br />Client.Dpm_client_id = '10380688' <br /><br />sqlstmt2 : <br />==========<br />We are running a procedure to dump the record in a temproray table.<br /><br />Begin <br />Tranrep (To_date('01-Jan-1999','dd-mon-yyyy'), <br />To_date('07-Sep-2000','dd-mon-yyyy'), '10380688',1,'8'); <br />End; <br /><br />sqlstmt3 :<br />==========<br />This query is used for retriving the data from the temporary table.<br /><br />Select FLAG, ISIN_CODE, ISIN_NAME, <br />ACCOUNT_TYPE, MARKET_TYPE, <br />SETTLEMENT_NUMBER, <br />TO_CHAR(BOOKING_DATE,'DD-MM-YYYY') BOOKING_DATE, <br />TO_CHAR(TRANSACTION_DATE,'DD-MM-YYYY') TRANSACTION_DATE, <br />DPM_REFERENCE_NO, PARTICULARS, <br />TO_CHAR(QUANTITY) QUANTITY, <br />TARGET_DP_ID, <br />TARGET_CMBP_ID, <br />CMBP_NAME, <br />DP_NAME, <br />TARGET_CLIENT_ID, <br />BKG_NARRATION, <br />TRANSACTION_TYPE, <br />TO_CHAR(TRANSACTION_ID) TRANSACTION_ID, <br />TO_CHAR(CLIENT_ID) CLIENT_ID, <br />DPM_CLIENT_ID, CLIENT_CATEGORY, <br />TO_CHAR(OPENING_BALANCE) OPENING_BALANCE, <br />DRCR_INDICATOR <br />FROM <br />TRANSACTION_REPORT <br />WHERE <br />USER_NAME = '8' AND <br />BRANCH_ID = 1 <br />ORDER BY FLAG,ISIN_NAME,ACCOUNT_TYPE DESC,Transaction_report.BOOKING_DATE <br /><br /><br /><br /><br />The following is the configuration that the project is running:<br />================================================== =============<br /><br />IIS 4.0<br /> Script time out 360 seconds<br /> Session Time Out 20 mintues<br />Oracle 8i <br /><br /> Hybried Database<br /><br /> optimizer_mode = CHOOSE<br /> db_block_buffers = 346<br /> db_block_size = 8192<br /> distributed_transaction = 10<br /> open_cursors = 200<br /> open_links = 4<br /> shared_pool_size = 94557184<br /> sort_area_size = 66560<br /> <br /> I am using only one user name to login to the database.<br /><br /> <br />Using Oracle ODBC 8.01.55.00<br /><br /> I have disabled the Enable Query Time Out option.<br /> <br /><br />ASP 2.0<br /><br /><br /><br /><br />Please help me.<br /><br />Regards<br /><br />S. Velayutham.<br /><br /><br />