Solved

Force Screen Refresh during initial page load

Posted on 2010-08-31
2
371 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Authentication of Web Services 3 54
Syntax error 9 45
convert html to string 6 22
SQL Exceptions 3 40
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

861 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

28 Experts available now in Live!

Get 1:1 Help Now