Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Force Screen Refresh during initial page load

Posted on 2010-08-31
2
Medium Priority
?
381 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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

824 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