Solved

Force Screen Refresh during initial page load

Posted on 2010-08-31
2
370 Views
Last Modified: 2012-05-10
I have a asp.net 3.5 (vb.net) application that after the user authenticates loads a large chunk of data, the issue is the screen just freezes until the data load is completed. This makes it look to the user like it has hung and they are closing the browser.  Is there a way to force the application screen to finish loading prior to making the call to the database or somehow thread the request so the page renders while its loading the data.  I know this must be a common problem but googling hasn't yeilded anything usable. Your advise is greatly appreciated.
0
Comment
Question by:clintnash
2 Comments
 
LVL 21

Accepted Solution

by:
silemone earned 500 total points
ID: 33570547
How are you pulling your data?

Have you tried using a dataset object?  

And are you using stored procedures?  Are you queries efficient?  If so, have you used indexes on your tables?

Can you show code?
0
 
LVL 1

Author Comment

by:clintnash
ID: 33570674
Once the user authenticates the page is redirected to a different aspx page.  In the page load event the following code is run.

<code>

        If Not IsPostBack Then
            Dim myreader As SqlDataReader = CType(SqlDS_SyncDB.Select(DataSourceSelectArguments.Empty), SqlDataReader)

            If Not (myreader Is Nothing) Then
                If myreader.Read() Then
                    loadsuccessfull = myreader("Returned").ToString()
                Else
                End If
            End If
        End If

</code>

The SQL Data Object is running a stored procedure which is copying data from a MySQL server setup as a view inside our MS SQL 2005 server (technically that procedure truncates a table, inserts roughly 400 to 1000 rows from the MySQL view, then runs updates based on values in a sql table) .  The MySQL server is a 3rd party applications database.  This update has to occur each time the application loads to refresh the data attempts to code directly against the MySQL Server yeilded results that we unusable because of speed. We are working to improve the performance of the load on the database side, but its server to server and is just going to be slow.

Ideally before the code above is executed the page would finish rendering and somehow using AJAX render with an updating notice.  Not concerned if the user is unable to do anything until the data is loaded, just want them to see something that confirms that application is still working...

Thanks for you help...
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now