Why some websites delay database updates?
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?
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?
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
it can depend on how much $$$ you can invest on hardware and software for your website ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER