I have a program that calls a thread, which starts an oracle connection and runs a query that takes about 5 minutes to complete. I want the user to be able to cancel the action if desired. When I call the Close() method on the connection, it takes a good 2 - 3 minutes to close the connection, and then the thread aborts. Is there some way I can get the connection to close faster?
View 1 RepliesI am using .net framework 4 and connecting to oracle 10 g via System.Data.OracleClient. It is working but it says it is deprecated and what else should I use instead of it?
View 2 RepliesIf I explicitly put an oracle connection in a Using{} block I know that it will call the Dispose() method when it goes out of scope. My question is will the OracleConnection object be disposed in the following code block:
[Code]....
The OracleConnection is implicitly within the Using{} block for the OracleCommand and goes out of scope at the same time.
I am working on a web application which is designed as master and web content pages. I designed login and logout for the application. When logout is clicked, it will call a method to clear the session variables and also some other methods which will clear some data in the oracle tables.
But if the user is clicking on the internet explorer close button, then there is no way to know that the application is closed. For this I got a link where we can write a javascript method and find the unload of the page and execute all of these but pages will be loading and unloading each time user navigates inside the application and I cannot depend on unloading the page.
how can I do all the process of clearing session and other things when user clicks close button of internet explorer.
Also this application needs to be holding the session for more than 1 or 2 hours, so session should not expire till logout is clicked or close button is pressed.
I want to show a popup about browser compatibility to the users visiting my website. I have used the popup in about 5 pages and it would be annoying for the users to see the same popup for more than once when they visit my website. So I am thinking to use a session and kill it when the user closes the poup. IT should not be shown until the browser is restarted.
View 4 RepliesI am using a adapted version ofhttp://www.mikesdotnetting.com/Article/45/Programmatically-accessing-data-from-DataSource-controlsDon't we need something like a closing-routine / close connection command after getting data from the database?If yes: What is the correct closing command?
View 2 RepliesWhen I run my piece of SQL through SQL developer it takes less than half a second with an overall cost of 618 on the explain plan.
When I run the same SQL through .NET via the oracle.dataaccess.client connection it is impossibly slow taking over 5 minutes to run.
What could be causing this and what can I do?
I am developing logging application with asp.net & vb.net & OracleAt present I'm using this mechanism to write logs
Method1 Connect (
Try{
Conn.open ()
[code]...
[Code]....
I can check whether username exists or not successfully but not for email. any ideas why it isn't working? Error message was that i did not close my connection. using System;
I have website which runs multiple threads. When user close the browser but threads are still running. How to kill/stop all thread in asp.net on browser close.
View 2 RepliesI have a web page with paypal. In the page user add items to list then buy it. when user add item to list i block that item in stock until user buy or delete that item.Now my problem is when user add item in the list and then close the broswer from IE close button , the item get blocked. I want to rollback the added items when user close the browser from IE button.
View 2 RepliesHttpResponse.End() seems to throw an exception according to msdn.Right now i have the choice of returning a value to say end thread(it only goes 2 functions deep) or i can call end().
I know that throwing exceptions is significantly slower (read the comment for a C#/.NET test) so if i want a fast webapp should i consider not calling it when it is trivially easy to not call it?
-edit- I do have a function call in certain functions and in the constructor in classes to ensure the user is logged in.So i call HttpResponse.End() in enough places although hopefully in regular site usage it doesn't occur too often.
There's so much hype about ASP.NET MVC these days, but the truth is that ASP.NET webforms is not going anywhere for some time. Is there any way for current developers to optimize ASP.NET webforms to perform as fast as ASP.NET MVC?
I have noticed a significant difference in speed between ASP.NET MVC and ASP.NET webforms. MVC is a lot snappier and loads pages faster than webforms. Can I achieve the same with ASP.NET webforms by optimizing it? If yes, what would you recommend?
We are playing video(avi) in our web site .Its taking time to play the file .Nothing is showing for 2 mins.Is there any way to streaming the file.for playing video file code is from this linkhttp://www.daniweb.com/code/snippet216568.html
View 3 Replieshow to make asp.net page fast render as fast as HTML page, this is my main and urgent requirement,
Acctualy My page conatins lots of data, images and videos from the database, so m facing the problem in page rendring, rendring is too slow, and client requires as fast rendring as HTML, i have studied a lot and found.....
Retrive data with the help of XML creates fast page rendring mean Retrive data from database in XML and then bind all the data in page from that XML file.
best way to read millions of record from sql server database.i have tried dataset but the performance is not good
View 5 RepliesI have used CKEditor in my ASP.NET pages. But after than, that pages are very slow. Is it possible that it is caused by CKEditor?
View 1 Replieswhen I access any page of my ASP.NET MVC website first time, then this first request is slow. It needs about 4-5 seconds to load. But every following request to any page is fast.When I wait some minutes or a hour then every first request is slow again. Every following request is fast.
I think that IIS 7 is compiling the code and keep it in memory. After some time it will delete it from memory so it needs to compile it again.What can I do that every first request is as fast as every following request?
(Without precompiling my source, if possible)
I have a page that shows statistics for users, this cannot be cached because each user has different statistics and there are many thus the real time query must be made.
What the way to avoid database server overload when user will click F5's to refresh or to ask different queries in short time intervals ?
I have the Problem with the File Upload window. When I used it the first time it works perfect but when I call the same functionality to open and upload a File the open button (in the "Choose File to Upload" Dialog) is pressed to fast. So the Test can not write the complete path of the File over set and so the I can not open the File. The Source Code of the function:
public void OpenFileDialogAndUploadCsvFileWithName(string fileName, IE editPage)
{
var fileUploadDialog = editPage.HtmlDialog(Find.ByTitle(PageTitle));
fileUploadDialog.WaitForComplete();
FileUpload fileUpload = fileUploadDialog.FileUpload(Find.ById(new Regex("_FileUpload")));
fileUpload.Set(fileName);
Image image = fileUploadDialog.Image(Find.BySrc(new Regex("/icons/upload.png")));
Element parentElement = image.Parent;
parentElement.FireEventNoWait("onmouseup");
parentElement.FireEventNoWait("onmousedown");
}
The Upload File Dialog is open from Internet Explorer Modal Dialog Window.
I have made an asp.net web application using VS 2008 to show crystal reports. I have used CrystalReportViewer control to show reports.
The table (sql server 2005 ) from which I have to fetch data has approximately 400000 records. I connect to it using OLEDB ( Microsoft OLEDB provider for sql server )
I have wrote the following code to achieve this :
[code]....
I have crystal report in asp.net 2.0 C# application..
It took me lot of time to show report at first time..
How to make fast to show report in some 10 sec or below..
Just like in title. It works much faster on IE (8, 9) than on firefox and chrome ?How is it possible ?
Whats more I had to disable cookies on aspxGridViews because I had bad requests all the time,
I need to create an Asp.net Calendar Control with Daily-weekly-Monthly & Yearly view This Control should Have Some Events , Properties and some Methods as its clear.
This Control should be capable to add tasks ( jobs) and some photos in each day Also Should have Remainder and should be Full Ajaxable.
So As I'm not familiar with Custom Control, What Do you recommand to read and whats your advise to have a fast and Stable Control.
Do You know Any Open Source ASP.net Control like this ?
I have used ajaxtool kit's autocomplete on a page which gets data from a webservice. This autocomplete is slow, at the time I only have 10 to 20 records in table and it take about 3 to 5 seconds to search and show result in autocomplete. User have to wait about 4 second on average to see data.
View 1 Replies