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:

Decrease First Load Time In MVC 2?

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

How To Decrease The Page Load Time In Application

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

AJAX :: Decrease Loading Time Of Update Panel On Panel Bar Item Click

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

Forms Data Controls :: Paging Style / Decrease The Height?

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

State Management :: Cache Data To Decrease Database Activity?

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

SQL Server :: Insert Large Amount Of Data In Sql Server 2005 Database With Every Time Duplicate Check?

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

.net - Can A 32 Bit Only DLL In Web Application Cause Performance Decrease

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

Waiting Screen While Response Is Awaited

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

Databases :: Decrease The Database Size From 40 GB?

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

Web Forms :: Decrease The Image Size?

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

Crystal Reports :: How To Decrease Width

May 7, 2015

how to decrease the width of the crystal report in asp.net

View 1 Replies

Waiting Screen While Redirecting To Other Domain Page

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

Display A Waiting Image On Page Load?

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

Security :: Time In LastLoginDate Field Ahead Of Local Server Time 3 Hours?

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

Web Forms :: Decrease Database File Size

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

The ShowTime Function Returns Server Time Or Client's Time

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

Icon/text On Top Of Current Page While Waiting For Db Call?

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

C# - Stopping A Page Waiting For Usercontrol To Finish Loading?

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

Web Forms :: Displaying Waiting Image When Page Is Loaded?

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

How To Calculate Time As User Can Change Server Time

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

Web Forms :: Upload Large Files - Stop Waiting For Uploading?

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

WCF / ASMX :: How To Asynchronous Call And Waiting For Function To Finish Processing

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

Web Forms :: Decrease The Load In A Lot Of Users Simulteniously Visit On Side?

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

DataSource Controls :: MS SQL Management Studio 2008 - Waiting Very Long For DB - Tree

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







Copyrights 2005-15 www.BigResource.com, All rights reserved