Solved

Force Screen Refresh during initial page load

Posted on 2010-08-31
2
375 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

724 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