C# - Speed Up Loading Data From Database?

Aug 30, 2010

I'm using Webservice which will return the data from the database through datatable and I'll convert the datatable into byte array. In front end, I'll reconvert the bytearray to datatable and used ajaxloader to display it in the form.. It is dynamic loading. So, for each click, it is taking 10 seconds to retreive the data regardless of the size of the data. So, I used static datatable and I've loaded all data in that datatable in page load event. But, no reaction. It is taking only same time. Even, there is no data to retreive, the ajax loader is going on loading for 10 seconds. Problem is with Ajax or my webservice??

My Code for listboxclick event

protected void listboxcity_SelectedIndexChanged(object sender, EventArgs e)
{
string sqlvalue = string.Empty;
//Thread.Sleep(200);
for (int i = 0; i < listboxcity.Items.Count; i++)

[Code]....

View 1 Replies


Similar Messages:

Forms Data Controls :: Increase The Speed Of Loading Images In Repaetercontrol?

Aug 2, 2010

I am facing problem with images loading time. In my form I have image server control placed in repeater control. The repeater control every time binds atleast 300 images. When we want to see all the images at a time the page is taking lot of time(atleast 3 to 4 mins) to display. But I need the page should be loaded fast.

The image url is from physical location.And the information related to image is coming from database.

I am using .net framework 3.5 and C#.net as language in asp.net web application.

View 3 Replies

Log Slow Loading Pages / How To Optimize Speed

Jan 11, 2011

Do you know of a library/httpmodule for logging slow loading pages (perhaps for a specific treshold) in an ASP.NET environment?

Google did not yield any results.

It would not be too hard to implement on my own, but why re-invent the weel.

View 4 Replies

C# - Improving Speed When Loading A List From A Web Service?

Aug 2, 2010

This is a continuation on this question:The problem is simple. I need to call methods from a REST web service which controls several tables. One table is a snapshot table which contains records with huge XML files. Each XML file is basically a backup from another database. This backup XML is then sent to customers who use the data as read-only information in another product. Basically, the data in the XML are lists of companies, products, business rules and whatever more. And no, those customers work offline most of the time, so they cannot get the data live.Walking through the list of snapshots is tricky: XMLData.Snapshots.Skip(N).Take(1).First(); but it works very nice. It's the answer of the previous Q.But there are three other lists of data that I need to walk through. These are called Changes, Errors and Messages. They contain (1) changes to the data, (2) errors that occurred during modifying the data and (3) generic messages. All of these records are linked to a snapshot record. Thus a single snapshot can contain multiple changes, errors and messages.

I still cannot access the server code but since there's a REST service wrapped around an entity framework exposing most of the functionality, I can still use that service. (And that service is only accessible internally, on the Intranet. This is basically what I have to work with. And while the lists of changes, errors and messages are relatively small, the snapshots are still huge.

The problem is that I now want to generate a client-side report of the changes, errors and messages, but without grouping them by snapshot! They need to be grouped by date. But each record also needs to show the title of the snapshot, which causes me some incredible headaches...When walking through e.g. the Changes with the regular foreach instruction I can load the Snapshot data by using XMLData.LoadProperty(Change, "Snapshots"); but since the snapshot record itself is generally about 300 MB, this just slows the whole thing down to a crawl. (There are tens of thousands of these records in total!) So I need a faster solution, without having to modify the server code.
Yeah, okay. Modifying the server would be the proper way but that's not possible. It's in production and this list isn't important enough to require an upgrade of the server. Basically, I'm not allowed to modify any server-code for now. (But they still want this list.)The application I'm working on is something that just needs to run once per week or per month. But with the current amount of records, I estimate it would take more than two days to finish. The data itself will be updated a few times every office day and snapshots are created every week or so on the server. Errors can always be generated when users start browsing the site which maintains the data but in general, there will be about 50 changes and 4 errors per week, plus a few messages when the server goes down and up again or when snapshots are generated.

View 2 Replies

How To Increase Speed For Loading Of Google Maps Embedded On Site

Feb 3, 2010

Are there any javascripts or other method which can decrease loading time of google maps? Google maps are added by iframe code.

Update: 12 FEB 2010

Can any jquery plugin be useful for me?

View 3 Replies

C# - Loading Items In Order And Increasing Web Application Speed Using Ajax

Jul 21, 2010

I want to implement the following page by Asp.net version 4.0 and ajax but I want to have loading by order like loading item 1 and 2 and so on. I have container or web part but mostly container like simple asp.net panel. how I can implement it ? I used updatepanel and update progress but it doesn't work that I have expected before.

View 3 Replies

Configuration :: Connection Speed To Database Server?

Feb 9, 2011

My web server and database server are currently both in the same room. However, the web server might be changed to a different server in another building about a mile down the street. I want to make sure this doesn't have a negative impact on the connection speed between the database and web server. Is there a way to test the connection speed from both web servers to the database?

View 3 Replies

AJAX :: Looking For A Good Guide To The Asynchronous Loading Of Data From The Database?

Mar 24, 2010

Looking for a good guide to the asynchronous loading of data from the database after 2 seconds from the page_load.I need a method that does not burden the operation site!

View 18 Replies

DataSource Controls :: How To Speed Up Data Access

Feb 26, 2010

I could use some guidance on a better way get get my data than I am using. This way is taking nearly 45 seconds to get the data and bind it to a gridview here are my methods used to get the data

[Code]....

then my data access class is:

[Code]....

View 1 Replies

ORM Vs Parametrized Queries If Only Concern Is Speed Of Data Access?

Jan 11, 2010

I work in an ASP.net/ SQL Server development environment. If my only concern is speed should I go with parametrized queries or should I use an ORM such as nHibernate or LINQ?

View 5 Replies

Forms Data Controls :: Speed Up Edit Gridview?

Jan 14, 2010

Sometimes my gridview can take a second or two to get into in edit mode, and other time it can be 5-10 seconds. Is there something I can do to make the transitions from each state more uniform?

View 3 Replies

WCF / ASMX :: How To Speed Up Response When Large Amount Of Data Is Returned

May 8, 2010

I have a WCF method that returns a huge number of rows, causing a long wait for end user.

Also I do not have IIS7 but only IIS 6 for my WCF.

Is there any way I can speed up the WCF response so user does not wait for a longer time?

View 4 Replies

Forms Data Controls :: DropDownList Binding - Ways To Increase Speed?

Oct 20, 2010

I have a gridview that displays query results on a reporting page for a "home-grown" CRM application. From the gridview, a link can be clicked which opens a modal window that contains an iframe linked to a "details" page where record specific info can be viewed/altered. On the details page there are 10 or so dropdownlists (ddls) that are bound every time the page is called. The ddls are bound using a method similar to the example below. I am looking for a way top speed things up a bit. The details page could be called 10-20 times in one session and every time the page loads these ddls have to be bound from the same methods but for different records. What are some options for speeding up the load time for this page??

[Code]....

[Code]....

View 6 Replies

Loading A Flash Video From A SQL Database?

Jan 12, 2011

I am trying to add flash videos to my intranet site. Instead of maintaining folders on our network with the videos in them and taking up space I am placing the videos into a SQL database that my application uses.On my video page I am using a flash control from http://www.flash-control.net/default.htmPS. I have tried the embed method with no luck.The work flow is as follows. The user logs into our site and is sent to a FAQ page. This page contains a gridview that check the DB and pulls out any entries. The user can then click on the entry in the gridview that they wish to view. If the item is a .swf video then the following happens.

View 3 Replies

Web Forms :: How To Increase Speed To Populate Dropdown List With Large Amount Data

Jan 11, 2010

I have Sql Table for Products that have ~8000 records. In my web form I want use dropdown list to edit code with dropdown list. This drop down list populate very slow. How to increase speed to populate dropdown list with large amount data.

View 1 Replies

Loading Images From Database In Mvcmusicstore Sample?

Feb 12, 2011

mvc musicstore sample application loads cart images using code below. In my application product images are store in database. How to modify this code so that images are loaded from database ?

<ul id="product-list">
<%
{ %>
foreach (var product in Model)<li>
<a href="<%= Url.Action("Details", "Store", new { id = product.Contents }) %>">
<img height="100" width="100" alt="<%= product.Name %>" src="Content/ProductImages/<%= product.Contents %>.jpg" />
<span><%= product.Name %></span>
</a>
</li>
<% } %>
</ul>

View 3 Replies

Loading Image From Database Using Http-handler?

Feb 11, 2010

In my MSSQL Server I have a table named Nomogram including an attribute named Img1 which include an image of type varbinary(MAX)I wish to load that image on my webform using an http-handler (ashx).How do I do that? I have looked at this sample but I can figure it out how to solve my exact problem. [URL]

View 29 Replies

DataSource Controls :: Creating / Loading DataTable Into SQL Server Database?

May 26, 2010

If I have a DataTable (in-memory) read by my C# program from a flat file, and I want to create it as a new table in a SQL Server database... what is the simplest way to do that?

It seems like something like SqlBulkCopy with an option to create a new destination SQL server table would be on my line of thinking, but I dont see a way.

View 6 Replies

AJAX :: Display Light Box Loading Image On Page When Update Panel Is Loading

Mar 6, 2013

I have update panel on the page to avoid postback and placed a dropdownlist control within that update panel. DrodownList is filled with Category names and also it's autopostback set to True.

Now whenever dropdownlist index change's on select, untill page loads complete  data it should show mesage as "Loading.... in center and middle of the page and background should become bit transparent". And when page load completely with data then that background and message should get disappear.

View 1 Replies

Crystal Reports :: How To Loading Gif Image While IE Progress Bar Start Loading

Apr 3, 2010

i have developed my asp.net application along wih crystal report .... i need to show loading image on ever client and server side request .... (i.e) like when ever IE progress bar get loading i want to show my gif loading ... after IE progress bar finish its loading, my gif loading image should disappear .

View 2 Replies

Want To Display A Loading Animation While Page Is Loading

Jun 23, 2010

I want to display a loading animation while my page is loading, and when loading is complete then obviously hide it.

I am working in ASP.NET using Masterpages, just wondering there is a a simple way of doing this using JQuery?

View 3 Replies

How To Speed Up Web Application?

Dec 4, 2010

I am writing an 3-tier enterprise asp.net web application which needs to be very lightweigt to lower the bandwidth usage. I want to speed up ASP.NET web page loading, I have minified all js and css, used AJAX, used less images in page, used paging for grids but still the overall response page size goes to nearly 1Mb because of viewstate hidden fields.

View 6 Replies

How To Speed Up Websites

Apr 15, 2010

im developing some backends in ASP.NET 2.0 and i have put all the images in Cache, GZIPED my CSS, JS files and everything to speedup the load of each options.

the performance its good and i have no problems with the clients but i want "MORE" fast loads and im looking for some recomendations.

Is important to mention that those websites are using only in intranets so im thinking to implement my next projects using IFRAME for content that way (i think) the options will be loading faster because they not have to load the entire site.

EDIT:

im not using viewstates i wrote HTML (code behing) generated controls and use as less as possible ASP.NET Rich controls, all my static contents are in Static vars (Header, Menu, Footer) but im just looking for speed up a litter more.

After compile my website i compress all the HTML, CSS, JS and use less of those files as possible.

but i was seeying others Backend that loads faster than my and the difference is the IFrame control that they use (i think), we check code, design, etc and we use the same (they use #INCLUDES for static HTML instead STATIC VARS with the HTML)

View 5 Replies

How To Measure Speed Of Application

Sep 13, 2010

Is there a way to measure the time elapsed for a web page to execute?

And if so, is it safe to use that figure to estimate the speed of the web page as the number of users grow and the database grows. Ie: if the page currently takes 1 second to process through x amount of rows in the database, to estimate it would take 2 seconds with 2x rows?

View 2 Replies

SQL Server :: Best Way To Speed Up Searching?

Feb 1, 2011

I have a web application running on ASP.NET 3.5 which basically stores, retrieves, and allows users to manipulate data from a SQL Server 2005 database. One of the features allows users to search through the records in the database. When the system was first launched last year, there were no records, so searches were lightning fast. However, over the past year, about 100,000 records have been entered, so most searches now take over 15 seconds to perform. I'd like to speed up searches, but there are problems with both of the conventional approaches I can think of:

Caching - The database does all the heavy lifting in this application - the ASP.NET web application is little more than a UI that passes user input to the correct stored procedure, and displays the returned output. The stored procedures are responsible for interpreting user input, applying the business rules, and transforming the underlying tables and views into a context-sensitive result set which the application just displays as is. Unless if there's a way to apply a stored procedure to a C# object/collection (the cached records), and get another C# object/collection back, effectively bypassing the database, I don't think this will work.Stored procedure optimization - There's some optimization potential here, but even a simple SELECT * FROM TheView statement on the underlying view currently takes 11 seconds according to SSMS, and I expect that the amount of time taken will continue to increase as more records are entered.Are there are techniques out there that I'm not aware of, which could be used to bring searching down to a reasonable amount of time (5 seconds or less per search)?

View 4 Replies







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