Skip to main content

Popular posts from this blog

FAQ's Salesforce Lightning Platform Query Optimizer

This article comprises the FAQs related to salesforce internal platform Query Optimizer.and provides valuable information that will help understand how to improve the performance of SOQL queries. For more information, you may also check this Dreamforce Session . 1. Query Optimizer Q: Does Salesforce have its own SQL optimization logic instead of Oracle's built-in? A: Force.com is a multi-tenant platform. To consider multitenant statistics, the platform has its own SOQL query optimizer that determines optimal SQL to satisfy a specific tenant's request. Q: How frequently generated are the statistics used by the query optimizer? A: Statistics are gathered weekly. Where statistics are not calculated, the optimizer also performs dynamic pre-queries, whose results are cached for 1 hour Q: Is there any way to flush the cache when doing your performance testing so your results are not cached biased? A: Unfortunately not. Queries with selective filters will perform mor...
1 comment
Read more

NoSQL Database (20 Best Free Open Source NoSQL Databses

  NoSQL databases are becoming popular day by day. I have come up with the list of best, free and open source NoSQL databases. MongoDB tops the list of Open Source NoSQL databases. This list of free and open source databases comprises of   MongoDB, Cassandra, CouchDB, Hypertable, Redis, Riak, Neo4j, HBASE, Couchbase, MemcacheDB, RevenDB and Voldemort.   These free and open source NoSQL databases are really highly scale-able, flexible and good for big data storage and processing. These open source NoSQL databases are far ahead in terms of performance as compared to traditional relational databases. However, these may not be always the best choice for you. Most of common applications can still be developed using traditional relational databases. NoSQL databases are still not the best option for a mission critical transaction needs. I have listed down a small description of all these best free and oper source NoSQL databases. Lets have a look.. 1. MongoDB MongoDB ...
Post a Comment
Read more

Introduction to Probability

Introduction to Probability Probabilities are associated with experiments where the outcome is not known in advance or cannot be predicted. For example, if you toss a coin, will you obtain a head or tail? If you roll a die will obtain 1, 2, 3, 4, 5 or 6? Probability measures and quantifies "how likely" an event, related to these types of experiment, will happen. The value of a probability is a number between 0 and 1 inclusive. An event that cannot occur has a probability (of happening) equal to 0 and the probability of an event that is certain to occur has a probability equal to 1.(see probability scale below). In order to quantify probabilities, we need to define the  sample space  of an experiment and the  events  that may be associated with that experiment. Sample Space and Events The  sample space  is the set of all possible outcomes in an experiment. Example 1:  If a die is rolled, the sample space S is given by S = {1,2,3,4,5,6} E...
Post a Comment
Read more