Solved

Why some websites delay database updates?

Posted on 2011-09-17
8
406 Views
Last Modified: 2012-06-27
Why some websites such as Wikipedia and some advertising networks delaying updating their database after user changes?

For example: A user add the keyword "Experts Exchange", why do it take time to affect the online campaign while they can update the database the same time?
0
Comment
Question by:Mohamed Abowarda
8 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 50 total points
ID: 36553558
replication might be 1 reason.
=> some sites are using several spread-over the world databases, so the "update" is not spread immediately to "all" those databases ...
validation another reason
another reason could be that (some) pages are being (re)generated based on content (changes), scheduled or triggered (but not realtime)
0
 
LVL 9

Assisted Solution

by:ghodder
ghodder earned 50 total points
ID: 36553591
It can also be due to content caching. Lots of larger sites use caches to reduce the load on their databases and improve the speed the pages load when you visit them.

Some pages could be configured to have a longer expiry timeout (e.g. if it is not anticipated that the page would be updated more than once per day) so the caching proxy will continue to serve the out-dated page until it reaches the expiry time.
0
 
LVL 13

Assisted Solution

by:khairil
khairil earned 50 total points
ID: 36553632
Other possibility, page like Wikipedia might have to be evaluate first by someone else before it can release the updated information to the mass. After validated all the changes then only the user can access the updated content.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 110

Assisted Solution

by:Ray Paseur
Ray Paseur earned 50 total points
ID: 36554256
When unauthenticated clients post comments, a moderator might want to review the comments.  I have a church web site that has an open calendar - anybody that wants to can post anything into the calendar.  But for obvious reasons we have a "gatekeeper" that may delete or modify inappropriate content.

Another possibility would make sense if it takes a long time to generate a dynamic page.  Example: The index.php page is only 100K but the complex queries needed to create the page take 10 seconds to run.  Rather than take a 10-second page load time, you can capture the output buffers and write the index.html version of the index.php page.  Then most clients will see the fast, static page.  A CRON job can periodically delete the index.html page, and the 404 handler can call the index.php page to rebuild the static version.
0
 
LVL 12

Author Comment

by:Mohamed Abowarda
ID: 36554338
Sometimes updating a "number" can delay, like for instance updating campaign budget.
0
 
LVL 12

Author Comment

by:Mohamed Abowarda
ID: 36554483
Another possibility would make sense if it takes a long time to generate a dynamic page.  Example: The index.php page is only 100K but the complex queries needed to create the page take 10 seconds to run.  Rather than take a 10-second page load time, you can capture the output buffers and write the index.html version of the index.php page.  Then most clients will see the fast, static page.  A CRON job can periodically delete the index.html page, and the 404 handler can call the index.php page to rebuild the static version.

In websites like Facebook, usually they have billions of records, why the database updates are instantly and don't take a lot of time to load?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 36554545
it can depend on how much $$$ you can invest on hardware and software for your website ...
0
 
LVL 5

Accepted Solution

by:
vop earned 50 total points
ID: 36557092
ISPs generally cache quite a bit of the web traffic passed by them as this can significantly reduce backbone bandwidth requirements.

The delay is proably a combination of this and the phenomena mentioned by other posters.

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

749 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