Home > database >  ASP.NET hourglass on loading page
ASP.NET hourglass on loading page

Time:02-26

On my new job there is a web-application written in Visual Basic .NET with usage of ASP.NET Webforms framework for producing and rendering of webpages. It runs on a Windows server and requires Microsoft IIS web-server as an application host. The project is developed with Microsoft Visual Studio 2010 as a development environment and uses Intersystems Cache database. The application has a layered architecture (Interface -, Business -, Data access layer).

We use Firefox (78.1.0.esr(64-bit) as browser (internal policy).

Users complain that they don't know when a page is loading / request is being processed. Apparently in the past Firefox visualized an hourglass when the page was loading.

What is the easiest way to visualize an hourglass for each request (independent of the page)? It's a very large application.

CodePudding user response:

For postbacks, you could use the asp:UpdateProgress control.

See: enter image description here

And FireFox

enter image description here

I am not aware of any changes in this area. However, it is BEYOND LAUGHABLE that some comments here suggest using ajax or some such!!! - I can provide some links to truck driving school, or maybe fast food training, as that is a laughable and gut busting suggestion here.

In fact? Introduction of ajax calls WILL FOR SURE remove any browser "waiting" or circle delay animated icon that MOST ALL browsers have when a page is loading.

Next up: Performance:

Well, does a page on the web site without any data load fast? In other words, do you have (or can you add a test page to the site - "hello world" on the page.

does that page load fast, or do all pages load slow. Or do pages with data operations and pages that pull data are slow?

And did the site run fast at one time, and is now with more data is it running slow? Or was it always slow? YOU REALLY need to answer the above questions.

Since you using a post-sql (or non sql database), then data in that system is actually saved in a format VERY simular to JSON, or XML. Just that the multi-value format used in that Cache database was invented in 1970, but that database uses strings for the data store.

In effect like say using google, or even SharePoint? You can have millions and millions of documents. Such computers even with low processor and low memory can easy say run a motor vechicles department for a whole country - 100 million people say.

So what they do AMAZING:

If you need to pull a patient reocord, or say a customer invoice? Such systems even with say 1 bilion reocrdss can pull that WHOLE invoice out of the data base with ONE disk operation and seek. They are blistering fast WHEN retriving what amounts to a master/child record compared to a sql system.

However, while those systems can say represent a whole invoice with one "string" (just like you can with XML or JSON?). What such systems do VERY poorly is "row" processing. So, get a reocrd, modify that reocrd, save it back? Fantasic performance.

However, row processing, or say using sql statements to update a lot of rows? That system is REALLY slow. And in fact, things are even worse since the ODBC drivers are in fact tranlating sql statements into "no sql, and into the string base database system).

So, I would ensure the data files are sized correctly. So, if that system used to run fast, but now is slow? The data files (their base size) need to be re-sized, and thus the huge mass of what we call "linked frames" will be reduced, and perforamnce should incrase huge. But you have to check the Cache database. (assuming that you have a few years of expreiance with that system).

So, do all web pages load slow - even ones without data? Then the can't be the databse.

Or, is this occuring for some database pages that involve say updates?

And did the developers use the "data cube" like data objects, or do they use the SQL (odbc) translaor for dealing with the database?

And was the system fast at one time? or was it always slow.

But, talking about a cube "no-sql" database, and THEN ALSO introduction of a simple browser question of which all have that "animation" icon? That is two VERY different questions here.

All current browsers I am aware of do have a "wait" type of animation. But such animation have VERY little to do with application and database performance optimizing. Toss in that you using a so called post-relational, or so called multi-value database, then you introducing an area of expertise that most posters here likely don't have. (so you getting silly suggestions about ajax and the like).

I have 10 years of experience on those multi-value databases, and as noted, they are not fast at row processing, but pulling, update and save of a record? Then such systems can easy beat sql based systems performance wise.

So, was the system fast at one time, and now is it slow? Are all pages - even those without data from databased slow? Or are only some pages with data operations slow? Are they using Cache data objects, or are they using the database provider and sql?

  • Related