high_scalability high_scalability-2008 high_scalability-2008-230 knowledge-graph by maker-knowledge-mining

230 high scalability-2008-01-29-Speed up (Oracle) database code with result caching


meta infos for this blog

Source: html

Introduction: One of the most interesting new features of Oracle 11 is the new function result caching mechanism. Until now, making sure that a PL/SQL function gets executed only as many times as necessary was a black art. The new caching system makes that quite easy -- here is how it works.


Summary: the most important sentenses genereted by tfidf model

sentIndex sentText sentNum sentScore

1 One of the most interesting new features of Oracle 11 is the new function result caching mechanism. [sent-1, score-1.625]

2 Until now, making sure that a PL/SQL function gets executed only as many times as necessary was a black art. [sent-2, score-2.168]

3 The new caching system makes that quite easy -- here is how it works. [sent-3, score-0.989]


similar blogs computed by tfidf model

tfidf for this blog:

wordName wordTfidf (topN-words)

[('function', 0.524), ('black', 0.345), ('executed', 0.328), ('caching', 0.289), ('necessary', 0.243), ('oracle', 0.205), ('gets', 0.199), ('result', 0.186), ('new', 0.184), ('sure', 0.179), ('quite', 0.179), ('works', 0.143), ('easy', 0.143), ('times', 0.141), ('features', 0.137), ('makes', 0.131), ('making', 0.13), ('interesting', 0.121), ('many', 0.079), ('system', 0.063), ('one', 0.056)]

similar blogs list:

simIndex simValue blogId blogTitle

same-blog 1 0.99999994 230 high scalability-2008-01-29-Speed up (Oracle) database code with result caching

Introduction: One of the most interesting new features of Oracle 11 is the new function result caching mechanism. Until now, making sure that a PL/SQL function gets executed only as many times as necessary was a black art. The new caching system makes that quite easy -- here is how it works.

2 0.12896161 194 high scalability-2007-12-26-Golden rule of web caching

Introduction: Effective content caching is one of the key features of scalable web sites. Although there are several out-of-the-box options for caching with modern web technologies, a custom built cache still provides the best performance.

3 0.12414654 1218 high scalability-2012-03-29-Strategy: Exploit Processor Affinity for High and Predictable Performance

Introduction: Martin Thompson wrote a really interesting article on the beneficial performance impact of taking advantage of  Processor Affinity : The interesting thing I've observed is that the unpinned test will follow a step function of unpredictable performance.  Across many runs I've seen different patterns but all similar in this step function nature.  For the pinned tests I get consistent throughput with no step pattern and always the greatest throughput. The idea is by assigning a thread to a particular CPU that when a thread is rescheduled to run on the same CPU, it can take advantage of the "accumulated  state in the processor, including instructions and data in the cache."  With multi-core chips the norm now, you may want to decide for yourself how to assign work to cores and not let the OS do it for you. The results are surprisingly strong.

4 0.1120808 359 high scalability-2008-07-29-Ehcache - A Java Distributed Cache

Introduction: Ehcache is a pure Java cache with the following features: fast, simple, small foot print, minimal dependencies, provides memory and disk stores for scalability into gigabytes, scalable to hundreds of caches is a pluggable cache for Hibernate, tuned for high concurrent load on large multi-cpu servers, provides LRU, LFU and FIFO cache eviction policies, and is production tested. Ehcache is used by LinkedIn to cache member profiles. The user guide says it's possible to get at 2.5 times system speedup for persistent Object Relational Caching, a 1000 times system speedup for Web Page Caching, and a 1.6 times system speedup Web Page Fragment Caching. From the website: Introduction Ehcache is a cache library. Before getting into ehcache, it is worth stepping back and thinking about caching generally. About Caches Wiktionary defines a cache as A store of things that will be required in future, and can be retrieved rapidly . That is the nub of it. In computer science terms, a cac

5 0.090438284 1565 high scalability-2013-12-16-22 Recommendations for Building Effective High Traffic Web Software

Introduction: This is a guest post by Ashwanth Fernando, Software Engineer from the trenches at large scale internet companies. Inspired by the book "Effective Java" by Joshua Bloch, I wanted to share my holistic recommendations on building high traffic web software (i.e. web applications/services that serve high traffic loads). Some of these items may not be just about software design but also around surrounding areas such as the engineering organization, culture etc. Two disclaimers up front: 1) This is my opinion. 2) There will be real world situations where the below principles will be wrong as in all things "software". Please use common sense all the time. Consider using more than one datacenter There have been numerous horror stories about businesses, ahem going out of business because they just had a single datacenter. Its really important to have more than one data center if you want to protect yourself from natural disasters or electrical supply failures. Run all your datacen

6 0.090431303 843 high scalability-2010-06-16-WTF is Elastic Data Grid? (By Example)

7 0.085852951 280 high scalability-2008-03-17-Paper: Consistent Hashing and Random Trees: Distributed Caching Protocols for Relieving Hot Spots on the World Wide Web

8 0.084409684 492 high scalability-2009-01-16-Database Sharding for startups

9 0.084319457 574 high scalability-2009-04-20-Some things about Memcached from a Twitter software developer

10 0.079828925 297 high scalability-2008-04-05-Skype Plans for PostgreSQL to Scale to 1 Billion Users

11 0.079380885 538 high scalability-2009-03-16-Are Cloud Based Memory Architectures the Next Big Thing?

12 0.077804253 1052 high scalability-2011-06-03-Stuff The Internet Says On Scalability For June 3, 2011

13 0.077069603 1124 high scalability-2011-09-26-17 Techniques Used to Scale Turntable.fm and Labmeeting to Millions of Users

14 0.0767271 1621 high scalability-2014-03-28-Stuff The Internet Says On Scalability For March 28th, 2014

15 0.075270444 448 high scalability-2008-11-22-Google Architecture

16 0.075269945 1366 high scalability-2012-12-03-Resiliency is the New Normal - A Deep Look at What It Means and How to Build It

17 0.075205848 718 high scalability-2009-10-08-Riak - web-shaped data storage system

18 0.074615762 750 high scalability-2009-12-16-Building Super Scalable Systems: Blade Runner Meets Autonomic Computing in the Ambient Cloud

19 0.074558944 1355 high scalability-2012-11-05-Gone Fishin': Building Super Scalable Systems: Blade Runner Meets Autonomic Computing In The Ambient Cloud

20 0.073845208 1509 high scalability-2013-08-30-Stuff The Internet Says On Scalability For August 30, 2013


similar blogs computed by lsi model

lsi for this blog:

topicId topicWeight

[(0, 0.098), (1, 0.063), (2, -0.02), (3, -0.022), (4, 0.007), (5, 0.001), (6, -0.01), (7, 0.005), (8, -0.05), (9, -0.015), (10, -0.001), (11, -0.012), (12, 0.002), (13, 0.009), (14, -0.003), (15, -0.033), (16, -0.009), (17, -0.016), (18, 0.033), (19, -0.002), (20, -0.03), (21, 0.029), (22, 0.038), (23, 0.007), (24, -0.04), (25, 0.032), (26, -0.013), (27, 0.041), (28, -0.026), (29, 0.024), (30, -0.066), (31, 0.036), (32, -0.031), (33, -0.019), (34, -0.02), (35, -0.018), (36, -0.036), (37, 0.011), (38, 0.014), (39, -0.02), (40, -0.01), (41, -0.061), (42, 0.046), (43, -0.022), (44, -0.004), (45, 0.046), (46, -0.037), (47, -0.001), (48, 0.01), (49, -0.006)]

similar blogs list:

simIndex simValue blogId blogTitle

same-blog 1 0.97695029 230 high scalability-2008-01-29-Speed up (Oracle) database code with result caching

Introduction: One of the most interesting new features of Oracle 11 is the new function result caching mechanism. Until now, making sure that a PL/SQL function gets executed only as many times as necessary was a black art. The new caching system makes that quite easy -- here is how it works.

2 0.71454525 996 high scalability-2011-02-28-A Practical Guide to Varnish - Why Varnish Matters

Introduction: This is a guest post by Jeff Su from Factual. What is Varnish? Varnish is an open source, high performance http accelerator that sits in front of a web stack and caches pages.  This caching layer is very configurable and can be used for both static and dynamic content. One great thing about Varnish is that it can improve the performance of your website without requiring any code changes.  If you haven’t heard of Varnish (or have heard of it, but haven’t used it), please read on.  Adding Varnish to your stack can be completely noninvasive, but if you tweak your stack to play along with some of varnish’s more advanced features, you’ll be able to increase performance by orders of magnitude. Some of the high profile companies using Varnish include:  Twitter ,  Facebook ,  Heroku  and  LinkedIn . Our Use Case One of Factual’s first high profile projects was  Newsweek’s “America’s Best High Schools: The List” . After realizing that we had only a few weeks to increase our

3 0.69520521 247 high scalability-2008-02-12-We want to cache a lot :) How do we go about it ?

Introduction: We have a lot of dependencies to our SQL databases and we have heard that caching does help a lot as we move into scaling and providing better performance. So the question is what are some reliable software products out there that we could consider in this space ? We want to put a lot of frequently called database calls that do not change frequently into this caching layer. Also what would be an easy way to move only those database changes into the cache as opposed to reloading or pulling it into cache every few mins or hours. We need something smart that would just push changes to the caching layer as it happens. I guess we could build our own, but are there any good reliable products out there ? Please also mention how they play with regards to pricing 'cos that would be a determining factor as well. Thanks

4 0.68592346 1633 high scalability-2014-04-16-Six Lessons Learned the Hard Way About Scaling a Million User System

Introduction: Ever come to a point where you feel you've learned enough to share your experiences in the hopes of helping others traveling the same road? That's what Martin Kleppmann has done in an lovingly written  Six things I wish we had known about scaling , an article well worth your time. It's not advice about scaling a Twitter, but of building a million user system, which is the sweet spot for a lot of projects. His conclusion rings true: Building scalable systems is not all sexy roflscale fun. It’s a lot of plumbing and yak shaving. A lot of hacking together tools that really ought to exist already, but all the open source solutions out there are too bad (and yours ends up bad too, but at least it solves your particular problem). Here's a gloss on the six lessons (plus a bonus lesson): Realistic load testing is hard . Testing a large distributed system is not like a scientific experiment that can be conducted under ideal conditions. This is hard for the scientific minded to acce

5 0.67760879 1124 high scalability-2011-09-26-17 Techniques Used to Scale Turntable.fm and Labmeeting to Millions of Users

Introduction: In How to launch in a month and scale to a million users , Joseph Perla , Former VP of Technology and founding team of Turntable.fm, shares techniques he used to build and quickly scale his startups. The post is very well written and a must read. Here are the essentials: Keep it simple. Build API's before making the website or mobile apps. Keep interfaces small and single-purpose.  Get it right. Build in automated tests from the start. Create function tests, module level tests, and full integration tests. Run tests on every commit. No new code written while bugs exist. Don't hide power. Use Pebbles to write bug-free Javascript, a library to create complicated AJAX interactions by writing 0 javascript by adding a few extra HTML tags to code. Use procedure arguments to provide flexibility in an interface. Pass functions instead of parameters to support complicated scenarios. For example, a filter function return a boolean. Leave it to the client. Keep the server

6 0.67128706 359 high scalability-2008-07-29-Ehcache - A Java Distributed Cache

7 0.65438974 1396 high scalability-2013-01-30-Better Browser Caching is More Important than No Javascript or Fast Networks for HTTP Performance

8 0.64954543 1620 high scalability-2014-03-27-Strategy: Cache Stored Procedure Results

9 0.647717 164 high scalability-2007-11-22-Why not Cache from Intersystems?

10 0.64373261 467 high scalability-2008-12-16-[ANN] New Open Source Cache System

11 0.64220828 1311 high scalability-2012-08-24-Stuff The Internet Says On Scalability For August 24, 2012

12 0.64093077 353 high scalability-2008-07-20-Strategy: Front S3 with a Caching Proxy

13 0.63848162 910 high scalability-2010-09-30-Facebook and Site Failures Caused by Complex, Weakly Interacting, Layered Systems

14 0.63105458 696 high scalability-2009-09-07-Product: Infinispan - Open Source Data Grid

15 0.6293965 1321 high scalability-2012-09-12-Using Varnish for Paywalls: Moving Logic to the Edge

16 0.62565994 1346 high scalability-2012-10-24-Saving Cash Using Less Cache - 90% Savings in the Caching Tier

17 0.62200594 836 high scalability-2010-06-04-Strategy: Cache Larger Chunks - Cache Hit Rate is a Bad Indicator

18 0.62154639 174 high scalability-2007-12-05-Product: Tugela Cache

19 0.62102687 741 high scalability-2009-11-16-Building Scalable Systems Using Data as a Composite Material

20 0.61775792 886 high scalability-2010-08-24-21 Quality Screencasts on Scaling Rails


similar blogs computed by lda model

lda for this blog:

topicId topicWeight

[(1, 0.148), (2, 0.474), (61, 0.031), (79, 0.116), (85, 0.042)]

similar blogs list:

simIndex simValue blogId blogTitle

1 0.99523568 1283 high scalability-2012-07-13-Stuff The Internet Says On Scalability For July 13, 2012

Introduction: It's HighScalability Time (Good luck today): A Friday the 13th Postmorterama: James Hamilton with some high powered perspective on the report for the Fukushima Nuclear Accident. Apparently they haven't heard of the blameless post-mortem. Lots of interesting stuff, but this is a potentially disaster saving general lesson learned: operators can’t figure out what is happening or take appropriate action without detailed visibility into the state of the system. Evernote with a nicely detailed note on a recent outage . A kernel panic happened while upgrading two new “shard” servers with 3x as much RAM, SSDs instead of 15krpm disks, bonded networking, and an updated kernel. They had to revert and shite loves to happen when other shite happens. Heroku with their postmortem on what happened when AWS went down. They lost 30% of their instances across 3 AZs in the US-East region. Rich detail on the impact of the AWS, but not much on what they can do about it

2 0.99141675 910 high scalability-2010-09-30-Facebook and Site Failures Caused by Complex, Weakly Interacting, Layered Systems

Introduction: Facebook has been so reliable that when a site outage does occur it's a definite learning opportunity. Fortunately for us we can learn something because in  More Details on Today's Outage , Facebook's Robert Johnson  gave a pretty candid explanation of what caused a rare 2.5 hour period of down time for Facebook. It wasn't a simple problem. The root causes were feedback loops and transient spikes caused ultimately by the complexity of weakly interacting layers in modern systems. You know, the kind everyone is building these days. Problems like this are notoriously hard to fix and finding a real solution may send Facebook back to the whiteboard. There's a technical debt that must be paid.  The outline and my interpretation (reading between the lines) of what happened is: Remember that Facebook caches everything . They have 28 terabytes of memcached data on 800 servers. The database is the system of record, but memory is where the action is. So when a problem happens that i

3 0.99097246 1190 high scalability-2012-02-10-Stuff The Internet Says On Scalability For February 10, 2012

Introduction: HighScalability Tested, Mother Approved: 12,233TPS : Twitter @ Super Bowl;  11 Million Slices : Dominos @ Super Bowl; 500K requests per second : S3;  The great mobile money drain . Mobile: high resource costs, low revenue. Mobile traffic on Plenty of Fish is  growing at 3% a month , rising to 3 Billion pageviews a month, 40% of signups are mobile, and all traffic will soon be 60-70% mobile. The problem: how do you make money on mobile? Time to chuck microprocessors for a networks of cells?   How Networks of Biological Cells Solve Distributed Computing Problems : Computer scientists prove that networks of cells can compute as efficiently as networks of computers linked via the internet. We believe that there is a need for a network model, where nodes are by design below the computation and communication capabilities of Turing machines. Unrelated?   GDrive at last  and  S3 Drops Storage Pricing . If you are StackOverflow and your data is overflowing , what do you do? Mo

4 0.99092859 1006 high scalability-2011-03-17-Are long VM instance spin-up times in the cloud costing you money?

Introduction: Are long VM instance spin-up times in the cloud costing you money? That's the question that immediately came to mind when James Urquhart , in an interview at the  Stata Conference , made this thought provoking comment: the   faster you can get the resources into the hands of the people who use them, the more money you save overall . One of the many super powers of the cloud is elasticity , the ability to dynamically acquire and release resources in response to demand. But like any good superhero, their strength must also form the basis of a not quite fatal flaw. Years and years of angsty episodes are usually required to explore this contradiction. In the case of the cloud, the weakness reveals itself in slow VM spin-up times. Spinning up a VM in EC2 can take a little as  1-3 minutes , or can  average 5-10 minutes , or it can take much longer if there's heavy usage in your availability zone. EC2 is not alone. A common complaint about Google App Engine is the cold-start problem .

5 0.99075252 639 high scalability-2009-06-27-Scaling Twitter: Making Twitter 10000 Percent Faster

Introduction: Update 6: Some interesting changes from Twitter's Evan Weaver : everything in RAM now, database is a backup; peaks at 300 tweets/second; every tweet followed by average 126 people; vector cache of tweet IDs; row cache; fragment cache; page cache; keep separate caches; GC makes Ruby optimization resistant so went with Scala; Thrift and HTTP are used internally; 100s internal requests for every external request; rewrote MQ but kept interface the same; 3 queues are used to load balance requests; extensive A/B testing for backwards capability; switched to C memcached client for speed; optimize critical path; faster to get the cached results from the network memory than recompute them locally. Update 5: Twitter on Scala . A Conversation with Steve Jenson, Alex Payne, and Robey Pointer by Bill Venners. A fascinating discussion of why Twitter moved to the Java JVM for their server infrastructure (long lived processes) and why they moved to Scala to program against it (high level langu

6 0.99027276 50 high scalability-2007-07-31-BerkeleyDB & other distributed high performance key-value databases

7 0.98739839 1591 high scalability-2014-02-05-Little’s Law, Scalability and Fault Tolerance: The OS is your bottleneck. What you can do?

8 0.98670512 1628 high scalability-2014-04-08-Microservices - Not a free lunch!

9 0.98490661 967 high scalability-2011-01-03-Stuff The Internet Says On Scalability For January 3, 2010

10 0.98458797 551 high scalability-2009-03-30-Lavabit Architecture - Creating a Scalable Email Service

11 0.98399675 247 high scalability-2008-02-12-We want to cache a lot :) How do we go about it ?

12 0.98334891 359 high scalability-2008-07-29-Ehcache - A Java Distributed Cache

13 0.9828167 1199 high scalability-2012-02-27-Zen and the Art of Scaling - A Koan and Epigram Approach

14 0.98259276 662 high scalability-2009-07-27-Handle 700 Percent More Requests Using Squid and APC Cache

15 0.98201287 1155 high scalability-2011-12-12-Netflix: Developing, Deploying, and Supporting Software According to the Way of the Cloud

16 0.98016417 844 high scalability-2010-06-18-Paper: The Declarative Imperative: Experiences and Conjectures in Distributed Logic

17 0.9777438 673 high scalability-2009-08-07-Strategy: Break Up the Memcache Dog Pile

18 0.97769612 406 high scalability-2008-10-08-Strategy: Flickr - Do the Essential Work Up-front and Queue the Rest

19 0.97759134 174 high scalability-2007-12-05-Product: Tugela Cache

20 0.97634405 1001 high scalability-2011-03-09-Google and Netflix Strategy: Use Partial Responses to Reduce Request Sizes