Daniil Korbutrtriangle.hashnode.net·Jan 13, 2023On-policy and Off-policy algorithms in Reinforcement LearningReinforcement learning (RL) is a type of machine learning that enables agents to learn how to make decisions by interacting with an environment. The agent learns to maximize a reward signal by trying different actions and observing the resulting rewa...341 likes·7.2K readsMachine Learning
Atharva Bhuseatharvabhuse.hashnode.net·Jan 31, 2023FeaturedA Beginner guide to Mastering Re-rendering in ReactI had been working professionally with React for a year now, and while I have been able to build functional and feature-rich applications, I realized that I didn't have a solid understanding of how React's re-rendering process works. I think this is ...180 likes·3.8K readsReact
Brock Herionbrockherion.hashnode.net·Jul 2, 2022FeaturedIs your website climate-friendly?Did you know that websites have carbon footprints? It makes sense if you think about it. Every time you visit a site, you are making a request to a server for data. Each server takes some amount of energy to send that content back to you. Thus, every...118 likes·2.0K readsWeb DevelopmentWeb Development
Shubham Agrawalshubhamsweb.hashnode.net·Apr 17, 2023Optimizing Web Performance: A Guide to Essential Metrics and Techniques(Image is generated by Midjourney) Introduction Web performance is a critical factor that affects the success of any website. Users expect fast and responsive websites; if a site is slow to load, it can lead to high bounce rates and low engagement. T...19 likes·340 readsWeb Development
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Optimizing Your Database Operations: Essential Techniques for Query Performance with Schema DesignNormalization Normalization is a process of organizing the database schema to eliminate redundant data and minimize the data dependency. Normalization can help to reduce the amount of data that needs to be read and minimize the number of joins requi...Database Query OptimizationDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Boosting Your Database Performance: A Comprehensive Guide to Query Re-Writing for Query OptimizationQuery rewriting is a technique used to optimize database query performance by transforming a complex or inefficient query into an equivalent, more efficient form. This technique involves using rules or algorithms to modify the query structure or exec...Database Query OptimizationDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Maximizing Query Performance: Essential Parallel Execution Techniques for Database OptimizationParallel execution is a technique used to optimize database query performance by dividing a query into smaller tasks that can be executed simultaneously on multiple processors or cores. This approach can help to reduce the total execution time of a q...Database Query OptimizationDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Getting the Most Out of Your Queries: Best Practices for Partitioning Database QueriesDatabase query optimization through partitioning involves dividing large database tables into smaller, more manageable pieces, which can help improve query performance. The partitioning technique involves dividing a table into smaller, more manageabl...Database Query OptimizationDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Caching Database Queries 101: Techniques Every Developer Should KnowUse a query cache plugin: Many database systems provide query cache plugins that can be used to cache the results of frequently executed queries. These plugins typically allow you to configure the size of the cache and specify which queries should be...Database Query OptimizationDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Optimizing Database Queries: Best Practices for JOIN OperationsJOINs are used to combine data from two or more tables into a single result set, but they can be expensive to execute, especially when the tables being joined are large. Here are some examples of JOIN optimization techniques that can be used to impro...Database Query OptimizationDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Database Query Optimization 101: Techniques Every Developer Should KnowDatabase query optimization refers to the process of analyzing a SQL query and finding the most efficient way to execute it. This involves selecting the optimal query execution plan that minimizes the time and resources required to complete the query...Database Query OptimizationDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Choosing the Right Indexing Strategy: Clustered vs Non-Clustered IndexesWhen deciding whether to use a clustered or non-clustered index in a database, there are a few factors to consider: Table size and data distribution: If the table is relatively small, a clustered index may not provide significant benefits, and a non...Database IndexingDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Basic difference between a Clustered Index and a Non-Clustered IndexIn a database, an index is a data structure that allows for quick access to specific data within a table. Indexes can be categorized into two types: clustered and non-clustered indexes. Clustered Index A clustered index determines the physical order ...Database IndexingDatabases
