To Find A Way Out To Reduce The Data Fetching Time?
Mar 21, 2011
I need to do parallel processing in my coding because i have 4 sql to fetch data from database which each take me 3-4 minutes.All the tables involved are raw table and that is no way i can reduce the time for the sql.I need to find a way out to reduce the data fetching time.The only thing i canfigure out is to have this 4 sql execute at the same time by doing parallel processing.
I have stored images in folder each images is more than 700kb so datalist binding process became slow.so it is possible that while loading record and corresponding images from folders Can I reduce the image size or compress images so that record fetching become faster.In database i m stroing image path and image is stored in directory.
I have a variable called "Totaltime" in my program. I assign the variable (in seconds) as Totaltime = 3600. Now i want to reduce the time by 1 sec for each Tick event and show the reducing time in label or litera control. tell the C# ASP.NET coding to implement this?
I am facing a problem related to webpage loading. After analysing the problem I got the conclusion that this is because of the use of third party control (Telrik Control) on the page.
it loads "ScriptResource.axd?d=VHFRlHPU4ruHmOYm-mEPLk5XeFL0XZCCksSiaq9cH120I4XzMjzdvS3A-Z1Q4FSlJuGkXycxn8tvOxEGZvni7w2&t=634068427680000000"
type of scripts on browser so it take time to load the page. Is there any way to reduce time of loading page?
My new office project is based on an MVP design and is in VB.NET (.NET 3.5), using multiple libraries (like EntLib, internal corporate framework, etc.). The number of DLLs used as references is so huge (almost 50) that when I try to build/debug the application in VS2008, it takes almost 3-4 minutes to get the website running successfully.Wanted to know if there are any settings/areas which upon some modifications can help me reduce the build time? and what exactly can be the major reasons behind this long loading duration?
I am binding the XML Data to treeview using XMLDataSource. Its working fime, but when the Number of nodes and childnodes increases, the treenode expand and to display the content in iframe takes moer time.
I am using the System.Timers.Timer class. And I enable when I send a message and disable when I receive the message. How do I calculate how much time has elapsed. I have set the interval as 1 sec
Basically I retransmit data after 1000 sec again if I do not recive an ACK. I retransmit 5 times max until I get a Ack. If I receive and something before 150ms then I stop retrnsmission.
As I am using two mkb time picker n gridview. For each mkb I use two button for In one button and for out another button. When I insert outtime automatically calculate the difference?
How can I fetch the first two information from it into my aspx page? for example I want to read the first two timings.. Should I use xmlReader or what?
1)usign execute scalar i will get 1st col and 1st row value.
2)using dataset i will get whole table.. if my stored proc has 2 queries then i will get 2 tables within same dataset.. i can reference therese using ds.tables(0).rows(value).
3)suppose i use a datareader then i will get multiple-rows. i want to know how to get these each separate rows coloumn values into variables. below is the reader aspx.vb
reader = cmd.ExecuteReader(); while (reader.Read()) {
4)what is it mean by data reader is forward only method of getting data.
5)why do we do readeritem.tostring()
6) can you tell me the basic how is this reader,ds,scalar works.i mean i know to use but donot know basics esspecially the dataadpapter.why do we fill it when using dataset.
I have a webservice which needs to query the Database every hour to get the latest copy of the data. What would be the best way to have the websevice call a method every hour. I am condering using the imers.Interval to call a method every hour.
I have a gridview which is present inside a repeater. I have been successful in displaying the data inside the grid view. Now I want to fetch data from the gridview. But i have not been able to fetch the data from the grid view.
I have two databases (DB1 & DB2) from which i wish to build a single table/gridview output, ideally i want to be able to sort the table by using any data.
However i cannot seem to figure out how to have more than one datasource per Gridview, and if i have more than one Gridviews then i can't sort all the data by any of the columns.
This is a oneway street, i do not want to update the databases from the webfront end.
My application has GRID VIEW control, which displays, Folder Name and Folder Path. While rendering in the webpage, i want to display only the Folder Name. For this, i set the visible property to false. Now iam able to display only Folder Name column.
Now the problem is, though iam hiding the Folder path column, i want to retrieve, the Folder path, when user clicks on submit button. Iam getting empty value for the hidden column.
I am fetching data from oracle data base in asp.net application. To achieve this functionality i have used Oracle.DataAccess dll . In my developement enviorment it working fine.
But once I deployed this code on IIS 6.0 it is stopped working and I checked my log and found connection not get established . Then I make sure Oracle.DataAccess.dll present in to bin folder also I try to put this dll in side GAC, but still my code is not working on deployed server.