SQL Server :: Decrease Data Waiting Time?
Nov 29, 2010
I have some difficulties in one of the web based projects that I've developed.
It's a country wide project and database is big, so the waiting time is getting increasing. I tried to write non- complex queries and set up index on some important fields that are being searched as well.
Is there any other way to enhance the efficiency and performance?
View 3 Replies
Similar Messages:
Jan 10, 2011
I have an ASP.net MVC 2 application that runs well locally. However when I move the files to my production server, I get a first time lag of about 30 seconds, I assume this is a first compile. After that the application works fine. Then after about 20-30 minutes of non use, the applications takes another 30 seconds or so to load.
I did try to precompile the code, but there is still a lag during the first load.
Are there any trick to getting the application to work faster on the first load?
I am using ASP.net 3.5, IIS 6 , visual studio 2010, MVC 2.
View 3 Replies
Jun 30, 2010
How to decrease the page load time in ASP.NET application? What should be the precautions and specially when we are interacting with databases
e.g.
wise use of viewstate
Set in web.config when deploying the app
etc
View 9 Replies
Jan 2, 2010
I have a panel bar..each time I press panel bar item I display ascx control with in update panel..but it lakes update panel loading time lot..how I can decrease that loading time?
View 2 Replies
Sep 30, 2010
I m doing paging in gridview. The paging one which acts like footer is of more height. I m trying to decrease the height but it is not working. when I m trying to increase it working.
View 3 Replies
Apr 1, 2010
Im working on my first ASPX webpage now, and Im wondering if there is some way to make a cache?
With a cache, I mean a list of variables that gets transferred from a db to for insance a hashtable the first time a user loads the page. When the next user loads the page, the db doesent get touched, but the variable is collected from the hashtable.
I tried to make a static class, but it re-loaded for each time I refreshed the page.
View 8 Replies
Feb 6, 2011
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
View 33 Replies
Dec 7, 2010
Web forms .NET application, is starting to meet 64 bits Windows servers and we have a 32bit DLL from one of our component vendors (its a hardware key, actually). I checked the instructions here "compiling a .net application with either a 32-bit or 64-bit dll". It is also what our vendor sugested. question: is there a performance impact on compiling a web application to run on x86 mode ?Please don't flame me for using a hardware key
View 1 Replies
Jul 17, 2010
I have a one iframe in which one webservice has opened .A forms is in that web service.After submitting that form my iframe will close.But before closing iframe I want some waiting screen till the form data is submitted at web service and receieved some response from there(like please wait while your operaion is processed). suggest me some good code snippet or link.I want to do it with jquery.My application is in .net.
View 1 Replies
Jan 8, 2010
I have one desktop application which is maintain all information related to laws of high court. we have stored lots of data in my application and now
our database size is almost 40 GB.
So my application runs quite slow.
How can i reduce the database space on my hard disk.
View 3 Replies
Jun 29, 2010
In my application image size is comming as 99999 in byte.so that i m unable to view my page because its too large.
so i want to decrease that size.
View 3 Replies
May 7, 2015
how to decrease the width of the crystal report in asp.net
View 1 Replies
Jul 14, 2010
I have one page from which i have to redirect to a page which is in some other application or can say in other domain.I want waiting screen till the page is loaded.I want to do it by jquery.
View 1 Replies
Jan 27, 2011
I want to show a waiting image/progress bar on page load event. In page load event, some code is being processed for displaying a report which takes 1/2 minutes to display on the aspx page, meanwhile the aspx is being empty and nothing is displyed, this is not so userfriendly. So, I want to show an image indicating page is being processed. I tried searching in google and found some code samples but couldnt achieve my target. How to implement this. Requirement is nothing but: Display an image/progress bar until the report is processed.
View 1 Replies
Mar 25, 2010
In my asp.net application I user Microsoft Membership to manage site access security and find the time saved into LastLoginDate is ahead of local time (Eastern Time Zone) 3 hours. What is wrong with it and how to ajust it to local time by application system only such as changing some properties od application?
View 2 Replies
Nov 28, 2013
I want decrease my database's file size I mean I want decrease .ldf and .mdf file's size... How I can do it?
View 1 Replies
May 12, 2010
Here is a bunch of code from a certain site;
Code:
<script type="text/javascript">
function ShowTime() {
[Code]....
the ShowTime function returns server time or client's time.However, I know that javascript executes in the client side.
View 3 Replies
Oct 4, 2010
using vb.net/asp.net 2005.
I have a page where the user will select criteria from drodownlists and then click the "go" button.I would like to create some kind of progress template or progress-bar so that the user will know that the query is in progress. What are the best and easiest options for this?I just want a simple thing like a rotating sand clock,
View 2 Replies
Jan 28, 2011
Is there a way of stopping the main page waiting for a usercontrol to load before it can finish loading?
I have a usercontrolthat has to do a lot of DB calls which can take a few seconds making the page slow to load. Ideally I'd like the main page to load straight away and then the usercontrol content appear when it is ready.
View 4 Replies
Oct 3, 2010
I want to display gif image when a page is loaded...I have a dropdown list when this is selected Gridview is populated with data from database..I want to show a gif image when this gridview is populated...how to implement this without AJAX...
View 5 Replies
Apr 8, 2010
I am trying to implement a license in which we will provide a license file which will be placed on the server root directory.This license file contain encrypted strings which have ServerName, Concurrent Sessions , Timeperiod.n this i have two issue.How could i calculate time as user can change server time.How could i maintain the concurrent login sessions [because i can't catch the event hen user close the browser].I will welcome any tehcnique otehr then javascript solution.[even polling] but i can't save session information in database
View 2 Replies
Sep 24, 2010
What is better way to large upload file. using a web service or in application itself. If in application, how can we check that files is to upload. actually i dont want user to wait for complete uploading, when it starts uploading user will get response of uploaded and uploading will be done in backgroud. I am not sure this type of task can be done in webservice also so that user doesnot need to wait for complete uploading. and one more query which event fires when the page redirects to another page. Is it Page_UnLoad or Dispose.
View 2 Replies
May 10, 2010
I have to call a function to run a report through a web service, then call another function to get the data but only after the 1st function has finished processing. How do I make c# wait till the first function has finished processing to run the second function?
my code looks something like:
NetworkCredential Cred = new NetworkCredential("uid", "pw");
ReportWebService reportService = new ReportWebService();
reportService.Credentials = Cred;
string s = reportService.runReportAsync("0ede9884e6394daf73fa418e9bffd4fc");
string report = reportService.getReportData(s);
This code will break because s is not set since the function (runreportasynch) has not finished running to produce s.
View 1 Replies
Aug 28, 2010
I an developing a asp.net website using c#.can anybody suggest how to decrease the load in a lot of users simulteniously visit on my side
View 4 Replies
Mar 22, 2010
I installed MS SQL Express 2008 with Advanced Services including Management Studio 2008. When I connect to the SQL server of my provider (shared hosting - one SQL server for many customers), it takes very long (up to serveral minutes) until all DBs are displayed in the object explorer (from which I then have to choose my DB). Somebody told me, the long waiting time occurs because Management Studio first checks rights (whichever rights that may be) with every DB that runs on the server.
But in Management Studio 2005 the behaviour is different - the DB Tree in the object explorer expands immediately! No waiting time! Does anyone know a solution for this? I don't want to install two separate versions of Management Studio just because of that!
View 1 Replies