{"store":{"baseInfo":{"podcastTitle":"Polyglot Software Development","slug":"snowpal","podcastDescription":"We’ve been doing Software Development and Architecture work for a while at Snowpal, and currently have several B2B and B2C products in production. In this podcast, we’ll share our experiences on a regular basis to help you & your teams build great software. The topics covered in this podcast will include Product Management, Project Management, Architecture, Development, Deployment, Security, Release Management, Sales, Marketing, Advertising, and just about everything else an ambitious, fast growing startup based out of the US is likely to be involved in. So, join us. Let’s become better!","podcastLogo":"https://pbcdn1.podbean.com/imglogo/image-logo/8090054/Podcast_Logo_2__rkadhf.jpg","podcastShareLogo":"https://d2bwo9zemjwxh5.cloudfront.net/image-logo/8090054/Podcast_Logo_2__rkadhf_1200x628.jpg?s=02af1ea1e6cf7255d87362ea88d7f06c&e=jpg","podcastUrl":"https://snowpal.podbean.com","podcastCanSearched":true,"feedUrl":"https://feed.podbean.com/snowpal/feed.xml","theme":"waves","podcastDeepLink":"https://www.podbean.com/pu/pbblog-4icbv-7b71c6","removePodbeanBranding":"no","brandingLogo":null,"timeZone":{"timeZoneId":17,"gmtAdjustment":"GMT-04:00","useDaylightTime":1,"value":-4,"text":"(GMT-04:00) Atlantic Time (Canada)","daylightStartTime":"Second Sunday Of March +2 Hours","daylightEndTime":"First Sunday Of November +2 Hours","timezone":"America/Halifax"},"podcastDownloads":null,"totalEpisodes":393,"showComments":true,"iOSAppDownloadLink":null,"customizeCssUrl":null,"androidAppDownloadLink":null,"showPostShare":true,"showLike":true,"author":"Krish Palaniappan and Varun Palaniappan","engagementStatsBaseUrl":null,"shareEmbedLink":"https://admin5.podbean.com/embed.html?id=pbblog-4icbv-7b71c6-playlist","language":"en","sensitivitySessionExpireTime":3600,"podcastApps":[{"name":"Apple Podcasts","link":"https://podcasts.apple.com/us/podcast/web-and-mobile-app-development-learn-from-us-learn-with-us/id1717981113","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/apple-podcast.png","title":null},{"name":"Podbean App","link":"https://r4j68.app.goo.gl/?link=https%3A%2F%2Fsnowpal.podbean.com%3Faction%3DopenPodcast%26podcastId%3Dpbblog8090054%26podcastIdTag%3D4icbv&dfl=https%3A%2F%2Fsnowpal.podbean.com&utm_campaign=pb_web&utm_source=podbean_web&utm_medium=dlink&imv=670&amv=530&isi=973361050&ibi=com.podbean.app.podcast&ipbi=com.podbean.app.podcast&apn=com.podbean.app.podcast","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/podbean-app.png","title":null},{"name":"Spotify","link":"https://open.spotify.com/show/6e9PfgA6LDKKPDW0w057vb","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/spotify.png","title":null},{"name":"iHeartRadio","link":"https://iheart.com/podcast/93363861/","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/iHeartRadio.png","title":null},{"name":"PlayerFM","link":"https://player.fm/series/3530865","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/PlayerFM.png","title":null},{"name":"Listen Notes","link":"https://lnns.co/VlD8t6F2Lny","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/ListenNotes.png","title":null},{"name":"Podchaser","link":"https://www.podchaser.com/podcasts/snowpal-software-development-a-1152661","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/Podchaser.webp","title":null},{"name":"BoomPlay","link":"https://www.boomplaymusic.com/podcasts/84448","image":"https://pbcdn1.podbean.com/fs1/site/images/admin5/BoomPlay.png","title":null}],"components":{"base":[{"id":"MainStyle","val":"dark"},{"id":"Font","val":"Open Sans"},{"id":"SecondaryFont","val":"Open Sans"},{"id":"PlayerColor","val":"#3A61B9"},{"id":"PlayerStyle","val":"player1"},{"id":"PlayerWave","val":"show"},{"id":"Favicon","val":null},{"id":"CookiesNotice","val":"hide"},{"id":"CookiesNoticeContent","val":"

Cookies Notice

This website uses cookies to improve your experience while you navigate through the website. By using our website you agree to our use of cookies.

"}],"home-header":[{"id":"HomeHeaderTextColor","val":"#CCCAB8"},{"id":"BackgroundImage","val":"https://mcdn.podbean.com/mf/web/mde6nn/Untitled_design_3_46565fd1-8f4c-e0ef-c5fb-cd3590bb2d59.png"},{"id":"BackgroundImageForMobile","val":null}],"page-header":[{"id":"PageHeaderTextColor","val":"#ffffff"},{"id":"PageHeaderBackgroundColor","val":"#FF5C84"}],"episode-list":[{"id":"EpisodeListType","val":"list"},{"id":"EpisodesPerPage","val":10},{"id":"EpisodeStats","val":"show"}],"navigation":[{"id":"NavigationFontColor","val":"#ffffff"},{"id":"NavigationBackgroundColor","val":"#000000"},{"id":"NavigationSearch","val":"show"},{"id":"NavigationLinks","val":[{"id":"Home","type":"Link","value":"/","text":"Home","subitems":[]},{"id":"Subscribe","type":"Link","value":"https://www.podbean.com/site/podcatcher/index/blog/6N8zX2HzDun3","text":"Subscribe","subitems":[]},{"id":"Profile","type":"Link","value":"https://www.podbean.com/user-1qOoopsaAuDq","text":"Profile","subitems":[]}]}],"footer":[{"id":"FooterType","val":"Footer1"},{"id":"FooterFontColor","val":"#ffffff"},{"id":"FooterBackgroundColor","val":"#000000"},{"id":"FooterCopyright","val":"Copyright 2024 All rights reserved."},{"id":"SocialMediaLinks","val":{"facebook_username":"","twitter_username":"","instagram_username":"","youtube_username":"","linkedin_username":""}}],"customize-container1":[],"customize-container2":[{"id":"ComponentText-1","val":{"ComponentFontColor":"#ffffff","ComponentBackgroundColor":"#1a1a1a","ComponentContent":"

Snowpal Project Management

Snowpal Pitch is a SaaS platform that allows you to create content, & structure it in a way that works best for you. It provides support to track your progress, measure your performance & collaborate with other members (be it students, teachers, coworkers, friends and/or family) by granting them varying levels of access to your content. Use in-app conversations, rely on badge notifications, customize your content layout & visualize reports through rich charts. Enjoy productivity.

"}}]},"allLinks":[],"mainStylesDefaultSettings":null,"defaultCustomizeComponents":null,"scripts":[],"metas":null,"appConfig":{"package":"com.podbean.app.podcast","app_store_id":973361050,"app_name":"Podbean","scheme":"podbean"},"customizeCss":null,"canEditCss":null,"enableJsCodeInCustomizeContent":false,"enabledIframeCodeInCustomizeContent":true,"sectionMaxCount":10,"enableEditorLink":true,"enableEditCookiesNotice":true,"siteRedirectToFeed":false,"podcatcherRssUrl":null,"showFeed":true,"showTopBar":true,"enableWebSiteLike":null,"organizationName":null,"organizationPageLink":null},"backToListUrl":"/","tinymceLoaded":false,"listEpisodes":[],"userLikedEpisodes":[],"topBarIframeLoaded":false,"listTotalCount":0,"listTotalPage":0,"listPage":0,"listType":"all","listValue":"","listName":"","pageLoading":false,"apiBaseUrl":"https://snowpal.podbean.com","apiCommonParams":{"t":"678dc95b","clientSignature":"95f0fdfab19aa60481ff839c870d4567","u":null,"customizing":null},"apiCommonHeaders":{},"comments":[],"commentsTotalCount":0,"commentsTotalPage":0,"commentsPage":1,"commentEpisodeId":"pb22055599-tt4w5","episode":{"id":"pb22055599","idTag":"tt4w5","title":"Databases & Denormalization - Faster queries for faster retrieval","logo":"https://pbcdn1.podbean.com/imglogo/image-logo/8090054/Podcast_Logo_2__rkadhf_300x300.jpg","shareLogo":"https://d2bwo9zemjwxh5.cloudfront.net/image-logo/8090054/Podcast_Logo_2__rkadhf_1200x628.jpg?s=02af1ea1e6cf7255d87362ea88d7f06c&e=jpg","largeLogo":"https://pbcdn1.podbean.com/imglogo/image-logo/8090054/Podcast_Logo_2__rkadhf.jpg","previewContent":null,"content":"

Whether you are designing a NoSQL Database or a traditional RDBMS Database, one way to optimize to ensure faster retrieval is to denormalize but that's not the best (or even the first) solution. You want to try out a few other things before resorting to denormalization.

#snowpal aws.snowpal.com learn.snowpal.com

","publishTimestamp":1700798292,"duration":580,"mediaUrl":"https://mcdn.podbean.com/mf/web/itu2zy/Podcasts6.mp4","mediaType":"video/mp4","shareLink":"https://admin5.podbean.com/embed.html?id=pb-tt4w5-1508aaf","likedCount":0,"deepLink":"https://www.podbean.com/ew/pb-tt4w5-1508aaf","transcriptUrl":null,"permalink":"/e/databases-denormalization-faster-queries-for-faster-retrieval-1700798292/","downloadLink":"https://www.podbean.com/site/EpisodeDownload/PB1508AAFTT4W5","fallbackResource":null,"fallbackResourceMimetype":null,"downloadCount":27,"status":"publish","hasMoreContent":false,"chaptersUrl":null},"episodeShareLink":null,"deepLink":"https://www.podbean.com/ew/pb-tt4w5-1508aaf","playlist":{"episodes":[],"current":0,"start":0,"stop":0,"playing":true,"playerLoading":true,"playbackRate":1,"playbackRateIndex":1},"toasts":[],"confirm":null,"customizeEditorFormZIndex":999,"lastRequestTime":null,"validateChangesOnBeforeunload":true,"windowWidth":1000,"VITE_FS1_CDN_URL_PREFIX":"https://pbcdn1.podbean.com/fs1","reloadStats":false},"episode":{"id":"pb22055599","idTag":"tt4w5","title":"Databases & Denormalization - Faster queries for faster retrieval","logo":"https://pbcdn1.podbean.com/imglogo/image-logo/8090054/Podcast_Logo_2__rkadhf_300x300.jpg","shareLogo":"https://d2bwo9zemjwxh5.cloudfront.net/image-logo/8090054/Podcast_Logo_2__rkadhf_1200x628.jpg?s=02af1ea1e6cf7255d87362ea88d7f06c&e=jpg","largeLogo":"https://pbcdn1.podbean.com/imglogo/image-logo/8090054/Podcast_Logo_2__rkadhf.jpg","previewContent":null,"content":"

#snowpal aws.snowpal.com learn.snowpal.com

Databases & Denormalization - Faster queries for faster retrieval

Comments (0)