CINXE.COM
Data Architecture Performance: Top Strategies
<!DOCTYPE html> <html lang="en"> <head> <meta name="pageKey" content="d_flagship3_web_collaborative_article"> <meta name="robots" content="max-image-preview:large, noarchive"> <meta name="bingbot" content="nocache"> <!----> <meta name="locale" content="en_US"> <meta id="config" data-app-version="0.0.4242" data-call-tree-id="AAYnkp6B0vg66MQ8omRNCw==" data-multiproduct-name="article-ssr-frontend" data-service-name="article-ssr-frontend" data-browser-id="6c09e597-ae07-4fa1-8b99-cb4220ab045d" data-enable-page-view-heartbeat-tracking data-page-instance="urn:li:page:d_web_collaborative_article;pufClcUPSym3V/0aXXJh1A==" data-theme="light" data-disable-jsbeacon-pagekey-suffix="true" data-member-id="0" data-logout-url="https://www.linkedin.com/uas/logout?session_full_logout=true&csrfToken=ajax%3A6238424174028928077" data-should-use-full-url-in-pve-path="true" data-dna-member-lix-treatment="control" data-human-member-lix-treatment="control" data-dfp-member-lix-treatment="control"> <link rel="canonical" href="https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc"> <link rel="alternate" hreflang="en" href="https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc"> <link rel="alternate" hreflang="x-default" href="https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc"> <!----> <!----> <!----> <link rel="manifest" href="/homepage-guest/manifest.json" crossorigin="use-credentials"> <link rel="icon" href="https://static.licdn.com/aero-v1/sc/h/al2o9zrvru7aqj8e1x2rzsrca"> <script> function getDfd() {let yFn,nFn;const p=new Promise(function(y, n){yFn=y;nFn=n;});p.resolve=yFn;p.reject=nFn;return p;} window.lazyloader = getDfd(); window.tracking = getDfd(); window.impressionTracking = getDfd(); window.ingraphTracking = getDfd(); window.appDetection = getDfd(); window.pemTracking = getDfd(); </script> <!----> <title>Data Architecture Performance: Top Strategies</title> <link rel="stylesheet" href="https://static.licdn.com/aero-v1/sc/h/gjqca1wf2zayj8qydu9z9xrh"> <meta name="description" content="Address data architecture performance issues with these strategies. Optimize indexing, use caching, and monitor resources to improve efficiency."> <meta property="og:title" content="Struggling with data architecture performance issues?"> <meta property="og:description" content="Address data architecture performance issues with these strategies. Optimize indexing, use caching, and monitor resources to improve efficiency."> <meta property="og:image" content="https://media.licdn.com/dms/image/v2/D4E12AQF9lAGr96l7SQ/article-cover_image-shrink_720_1280/article-cover_image-shrink_720_1280/0/1674665583433?e=2147483647&v=beta&t=ecvEVDwuRrhrjGu3yH6FokateCdM8Lav6Xa_1JitNnU"> <meta property="og:type" content="article"> <meta property="og:url" content="https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc"> <meta name="twitter:card" content="summary_large_image"> <meta name="twitter:site" content="@LinkedInEditors"> <meta name="twitter:title" content="Struggling with data architecture performance issues?"> <meta name="twitter:description" content="Address data architecture performance issues with these strategies. Optimize indexing, use caching, and monitor resources to improve efficiency."> <meta name="twitter:image" content="https://media.licdn.com/dms/image/v2/D4E12AQF9lAGr96l7SQ/article-cover_image-shrink_720_1280/article-cover_image-shrink_720_1280/0/1674665583433?e=2147483647&v=beta&t=ecvEVDwuRrhrjGu3yH6FokateCdM8Lav6Xa_1JitNnU"> <meta name="appId"> <meta name="twitter:label1" content="Written by"> <meta name="twitter:data1" content="Data Architecture"> <!----> <meta name="clientSideIngraphs" content="1" data-gauge-metric-endpoint="/advice/api/ingraphs/gauge" data-counter-metric-endpoint="/advice/api/ingraphs/counter"> <script type="application/ld+json"> {"@context":"http://schema.org","@type":"Article","headline":"Address data architecture performance issues with these strategies. Optimize indexing, use caching, and monitor resources to improve efficiency.","url":"https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc","publisher":"www.linkedin.com","name":"Struggling with data architecture performance issues?","commentCount":18,"interactionStatistic":[{"interactionType":"http://schema.org/LikeAction","userInteractionCount":2,"@type":"InteractionCounter"},{"interactionType":"http://schema.org/CommentAction","userInteractionCount":18,"@type":"InteractionCounter"}],"datePublished":"2024-11-15T18:52:26.000+00:00","mainEntityOfPage":"https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc","isAccessibleForFree":true,"image":{"url":"https://media.licdn.com/dms/image/v2/D4E12AQF9lAGr96l7SQ/article-cover_image-shrink_720_1280/article-cover_image-shrink_720_1280/0/1674665583433?e=2147483647&v=beta&t=ecvEVDwuRrhrjGu3yH6FokateCdM8Lav6Xa_1JitNnU","@type":"ImageObject"},"sourceOrganization":"www.linkedin.com"} </script> <!----> </head> <body dir="ltr"> <!----><!----><!----> <div class="guest-upsells"> <form class="google-auth base-google-auth" action="https://www.linkedin.com/uas/login-submit" method="post"> <input name="loginCsrfParam" value="6c09e597-ae07-4fa1-8b99-cb4220ab045d" type="hidden"> <input name="session_redirect" value="https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc" type="hidden"> <input name="trk" value="pulse-article_google-one-tap-submit" type="hidden"> <code id="termsAndConditionsRendered" style="display: none"><!--true--></code> <div class="google-one-tap__module hidden fixed flex flex-col items-center top-[20px] right-[20px] z-[9999]"> <div class="relative top-2 bg-color-background-container-tint pl-2 pr-1 pt-2 pb-3 w-[375px] rounded-md shadow-2xl"> <p class="text-md font-bold text-color-text"> Agree & Join LinkedIn </p> <p class="linkedin-tc__text text-color-text-low-emphasis text-xs pb-2 !text-sm !text-color-text" data-impression-id="pulse-article_one-tap-skip-tc-text"> By clicking Continue to join or sign in, you agree to LinkedIn’s <a href="/legal/user-agreement?trk=linkedin-tc_auth-button_user-agreement" target="_blank" data-tracking-control-name="linkedin-tc_auth-button_user-agreement" data-tracking-will-navigate="true">User Agreement</a>, <a href="/legal/privacy-policy?trk=linkedin-tc_auth-button_privacy-policy" target="_blank" data-tracking-control-name="linkedin-tc_auth-button_privacy-policy" data-tracking-will-navigate="true">Privacy Policy</a>, and <a href="/legal/cookie-policy?trk=linkedin-tc_auth-button_cookie-policy" target="_blank" data-tracking-control-name="linkedin-tc_auth-button_cookie-policy" data-tracking-will-navigate="true">Cookie Policy</a>. </p> </div> <div data-tracking-control-name="pulse-article_google-one-tap" id="google-one-tap__container"></div> </div> <div class="loader loader--full-screen"> <div class="loader__container mb-2 overflow-hidden"> <icon class="loader__icon inline-block loader__icon--default text-color-progress-loading" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/ddi43qwelxeqjxdd45pe3fvs1" data-svg-class-name="loader__icon-svg--large fill-currentColor h-[60px] min-h-[60px] w-[60px] min-w-[60px]"></icon> </div> </div> </form> <script data-delayed-url="https://static.licdn.com/aero-v1/sc/h/29rdkxlvag0d3cpj96fiilbju" data-module-id="google-gsi-lib"></script> <code id="isLinkedInAppWebView" style="display: none"><!--false--></code> <code id="shouldRemoveUndefinedValues" style="display: none"><!--false--></code> <code id="isItpSupportEnabled" style="display: none"><!--false--></code> <code id="isFedCMEnabled" style="display: none"><!--false--></code> <div class="contextual-sign-in-modal base-contextual-sign-in-modal" data-impression-id="pulse-article_contextual-sign-in-modal" data-cool-off-enabled data-show-on-page-load> <!----> <div class> <!----> <div id="base-contextual-sign-in-modal" class="modal modal--contextual-sign-in" data-outlet="base-contextual-sign-in-modal"> <!----> <div class="modal__overlay flex items-center bg-color-background-scrim justify-center fixed bottom-0 left-0 right-0 top-0 opacity-0 invisible pointer-events-none z-[1000] transition-[opacity] ease-[cubic-bezier(0.25,0.1,0.25,1.0)] duration-[0.17s] py-4 " aria-hidden="true"> <section aria-modal="true" role="dialog" aria-labelledby="base-contextual-sign-in-modal-modal-header" tabindex="-1" class="max-h-full modal__wrapper overflow-auto p-0 bg-color-surface max-w-[1128px] min-h-[160px] relative scale-[0.25] shadow-sm shadow-color-border-faint transition-[transform] ease-[cubic-bezier(0.25,0.1,0.25,1.0)] duration-[0.33s] focus:outline-0 w-[1128px] mamabear:w-[744px] babybear:w-[360px] rounded-md"> <button class="modal__dismiss btn-tertiary h-[40px] w-[40px] p-0 rounded-full indent-0 contextual-sign-in-modal__modal-dismiss absolute right-0 m-[20px] cursor-pointer" aria-label="Dismiss" data-tracking-control-name="pulse-article_contextual-sign-in-modal_modal_dismiss"> <icon class="contextual-sign-in-modal__modal-dismiss-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/gs508lg3t2o81tq7pmcgn6m2"></icon> </button> <div class="modal__main w-full"> <div class="contextual-sign-in-modal__screen contextual-sign-in-modal__context-screen flex flex-col my-4 mx-3"> <img class="inline-block relative w-16 h-16 contextual-sign-in-modal__img m-auto" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5k9cgtx8rhoyqkcxfoncu1svl" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9l8dv1r8a09nem281grvopn9l" alt> <h2 class="contextual-sign-in-modal__context-screen-title font-sans text-xl text-color-text my-2 mx-4 text-center" id="base-contextual-sign-in-modal-modal-header"> Sign in to view more content </h2> <p class="contextual-sign-in-modal__subtitle mb-2 mx-12 babybear:mx-0 text-center font-sans text-md text-color-text"> Create your free account or sign in to continue your search </p> <!----> <div class="contextual-sign-in-modal__btn-container m-auto w-[320px] babybear:w-full"> <!----> <div class="w-full max-w-[400px] mx-auto"> <div class="google-auth-button"> <!----> <div class="google-auth-button__placeholder google-auth-button__placeholder--black-border" data-theme="outline" data-logo-alignment="center"></div> <!----> </div> </div> <div class="sign-in-modal" data-impression-id="pulse-article_contextual-sign-in-modal_sign-in-modal"> <button class="sign-in-modal__outlet-btn cursor-pointer btn-md btn-primary" data-tracking-client-ingraph data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_outlet-button" data-modal="base-sign-in-modal"> <!----> Sign in </button> <div class> <!----> <div id="base-sign-in-modal" class="modal modal--sign-in" data-outlet="base-sign-in-modal"> <!----> <div class="modal__overlay flex items-center bg-color-background-scrim justify-center fixed bottom-0 left-0 right-0 top-0 opacity-0 invisible pointer-events-none z-[1000] transition-[opacity] ease-[cubic-bezier(0.25,0.1,0.25,1.0)] duration-[0.17s] py-4 " aria-hidden="true"> <section aria-modal="true" role="dialog" aria-labelledby="base-sign-in-modal-modal-header" tabindex="-1" class="max-h-full modal__wrapper overflow-auto p-0 bg-color-surface max-w-[1128px] min-h-[160px] relative scale-[0.25] shadow-sm shadow-color-border-faint transition-[transform] ease-[cubic-bezier(0.25,0.1,0.25,1.0)] duration-[0.33s] focus:outline-0 w-[1128px] mamabear:w-[744px] babybear:w-[360px] rounded-md"> <button class="modal__dismiss btn-tertiary h-[40px] w-[40px] p-0 rounded-full indent-0 sign-in-modal__dismiss absolute right-0 cursor-pointer m-[20px]" aria-label="Dismiss" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_dismiss"> <icon class="sign-in-modal__dismiss-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/gs508lg3t2o81tq7pmcgn6m2"></icon> </button> <div class="modal__main w-full"> <div class="sign-in-modal__screen flex flex-col py-4 w-[513px] babybear:w-full px-3"> <h2 class="sign-in-modal__header font-sans text-display-md text-color-text "> Welcome back </h2> <code id="i18n_sign_in_form_show_text" style="display: none"><!--"Show"--></code> <code id="i18n_sign_in_form_show_label" style="display: none"><!--"Show your LinkedIn password"--></code> <code id="i18n_sign_in_form_hide_text" style="display: none"><!--"Hide"--></code> <code id="i18n_sign_in_form_hide_label" style="display: none"><!--"Hide your LinkedIn password"--></code> <code id="i18n_username_error_empty" style="display: none"><!--"Please enter an email address or phone number"--></code> <code id="i18n_username_error_too_long" style="display: none"><!--"Email or phone number must be between 3 to 128 characters"--></code> <code id="i18n_username_error_too_short" style="display: none"><!--"Email or phone number must be between 3 to 128 characters"--></code> <code id="i18n_password_error_empty" style="display: none"><!--"Please enter a password"--></code> <code id="i18n_password_error_too_short" style="display: none"><!--"The password you provided must have at least 6 characters"--></code> <code id="i18n_password_error_too_long" style="display: none"><!--"The password you provided must have at most 400 characters"--></code> <!----> <form data-id="sign-in-form" action="https://www.linkedin.com/uas/login-submit" method="post" novalidate class="mt-1.5 mb-2"> <input name="loginCsrfParam" value="6c09e597-ae07-4fa1-8b99-cb4220ab045d" type="hidden"> <div class="flex flex-col"> <div class="mt-1.5" data-js-module-id="guest-input"> <div class="flex flex-col"> <label class="input-label mb-1" for="base-sign-in-modal_session_key"> Email or phone </label> <div class="text-input flex"> <input class="text-color-text font-sans text-md outline-0 bg-color-transparent grow" autocomplete="username" id="base-sign-in-modal_session_key" name="session_key" required data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_sign-in-session-key" data-tracking-client-ingraph type="text"> </div> </div> <p class="input-helper mt-1.5" for="base-sign-in-modal_session_key" role="alert" data-js-module-id="guest-input__message"></p> </div> <div class="mt-1.5" data-js-module-id="guest-input"> <div class="flex flex-col"> <label class="input-label mb-1" for="base-sign-in-modal_session_password"> Password </label> <div class="text-input flex"> <input class="text-color-text font-sans text-md outline-0 bg-color-transparent grow" autocomplete="current-password" id="base-sign-in-modal_session_password" name="session_password" required data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_sign-in-password" data-tracking-client-ingraph type="password"> <button aria-live="assertive" aria-relevant="text" data-id="sign-in-form__password-visibility-toggle" class="font-sans text-md font-bold text-color-action z-10 ml-[12px] hover:cursor-pointer" aria-label="Show your LinkedIn password" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_sign-in-password-visibility-toggle-btn" type="button">Show</button> </div> </div> <p class="input-helper mt-1.5" for="base-sign-in-modal_session_password" role="alert" data-js-module-id="guest-input__message"></p> </div> <input name="session_redirect" value="https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc" type="hidden"> <!----> </div> <div data-id="sign-in-form__footer" class="flex justify-between sign-in-form__footer--full-width"> <a data-id="sign-in-form__forgot-password" class="font-sans text-md font-bold link leading-regular sign-in-form__forgot-password--full-width" href="https://www.linkedin.com/uas/request-password-reset?trk=pulse-article_contextual-sign-in-modal_sign-in-modal_forgot_password" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_forgot_password" data-tracking-will-navigate>Forgot password?</a> <!----> <input name="trk" value="pulse-article_contextual-sign-in-modal_sign-in-modal_sign-in-submit" type="hidden"> <button class="btn-md btn-primary flex-shrink-0 cursor-pointer sign-in-form__submit-btn--full-width" data-id="sign-in-form__submit-btn" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_sign-in-submit-btn" data-tracking-client-ingraph data-tracking-litms type="submit"> Sign in </button> </div> <div class="sign-in-form__divider left-right-divider pt-2 pb-3"> <p class="sign-in-form__divider-text font-sans text-sm text-color-text px-2"> or </p> </div> </form> <div class="w-full max-w-[400px] mx-auto"> <div class="google-auth-button" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_google-auth-button" data-tracking-client-ingraph> <code id="isTermsAndConditionsSkipEnabledAuthButton" style="display: none"><!--true--></code> <p class="linkedin-tc__text text-color-text-low-emphasis text-xs pb-2" data-impression-id="pulse-article_contextual-sign-in-modal_sign-in-modal__button-skip-tc-text"> By clicking Continue to join or sign in, you agree to LinkedIn’s <a href="/legal/user-agreement?trk=pulse-article_contextual-sign-in-modal_sign-in-modal_auth-button_user-agreement" target="_blank" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_auth-button_user-agreement" data-tracking-will-navigate="true">User Agreement</a>, <a href="/legal/privacy-policy?trk=pulse-article_contextual-sign-in-modal_sign-in-modal_auth-button_privacy-policy" target="_blank" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_auth-button_privacy-policy" data-tracking-will-navigate="true">Privacy Policy</a>, and <a href="/legal/cookie-policy?trk=pulse-article_contextual-sign-in-modal_sign-in-modal_auth-button_cookie-policy" target="_blank" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_auth-button_cookie-policy" data-tracking-will-navigate="true">Cookie Policy</a>. </p> <div class="google-auth-button__placeholder google-auth-button__placeholder--black-border" data-theme="outline" data-logo-alignment="center"></div> <!----> </div> </div> <!----> <p class="sign-in-modal__join-now m-auto font-sans text-md text-color-text mt-2"> New to LinkedIn? <a href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=pulse-article_contextual-sign-in-modal_sign-in-modal_join-link" data-tracking-control-name="pulse-article_contextual-sign-in-modal_sign-in-modal_join-link" data-tracking-will-navigate="true" class="sign-in-modal__join-link">Join now</a> </p> </div> </div> <!----> </section> </div> </div> </div> </div> <div class="contextual-sign-in-modal__divider left-right-divider"> <p class="contextual-sign-in-modal__divider-text font-sans text-sm text-color-text px-2"> or </p> </div> </div> <p class="contextual-sign-in-modal__join-now m-auto font-sans text-md text-color-text my-1"> New to LinkedIn? <a href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=pulse-article_contextual-sign-in-modal_join-link" data-tracking-control-name="pulse-article_contextual-sign-in-modal_join-link" data-tracking-will-navigate="true" class="contextual-sign-in-modal__join-link">Join now</a> </p> <p class="linkedin-tc__text text-color-text-low-emphasis text-xs pb-2 contextual-sign-in-modal__terms-and-conditions m-auto w-[320px] pt-2 babybear:w-full" data-impression-id="linkedin-tc__button-skip-tc-text"> By clicking Continue to join or sign in, you agree to LinkedIn’s <a href="/legal/user-agreement?trk=linkedin-tc_auth-button_user-agreement" target="_blank" data-tracking-control-name="linkedin-tc_auth-button_user-agreement" data-tracking-will-navigate="true">User Agreement</a>, <a href="/legal/privacy-policy?trk=linkedin-tc_auth-button_privacy-policy" target="_blank" data-tracking-control-name="linkedin-tc_auth-button_privacy-policy" data-tracking-will-navigate="true">Privacy Policy</a>, and <a href="/legal/cookie-policy?trk=linkedin-tc_auth-button_cookie-policy" target="_blank" data-tracking-control-name="linkedin-tc_auth-button_cookie-policy" data-tracking-will-navigate="true">Cookie Policy</a>. </p> </div> </div> <!----> </section> </div> </div> </div> </div> <div class="cta-modal overflow-hidden container-raised z-10 fixed bottom-3 right-3 min-h-[56px] p-2 babybear:hidden windows-app-upsell windows-app-upsell--msft flex flex-col p-2 w-[359px] !bg-[#F1F8FA] opacity-90 backdrop-blur-[2px] z-1" data-impression-id="pulse-article_windows-app-upsell_cta-modal" role="dialog" aria-labelledby="cta-modal-header" aria-describedby="cta-modal-subheader"> <div class="windows-app-upsell__linkedin-title-container pt-[6px] mb-1.5 flex align-center"> <icon class="windows-app-upsell__linkedin-bug-icon block w-[21px] h-[21px]" data-svg-class-name="windows-app-upsell__linkedin-bug-icon-svg w-[21px] h-[21px]" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/euqjj7tf5wvr33frd3x1jj9s"></icon> <p class="windows-app-upsell__linkedin-title uppercase text-xs text-color-text-secondary leading-[21px] ml-1"> LinkedIn </p> </div> <p class="windows-app-upsell__title font-sans text-md text-color-text-accent-4-hover font-semibold leading-regular mb-1"> LinkedIn is better on the app </p> <p class="windows-app-upsell__body font-sans text-sm text-color-text-secondary leading-regular"> Don’t have the app? Get it in the Microsoft Store. </p> <a class="windows-app-upsell__cta btn-sm btn-secondary-emphasis mt-2 mb-[6px] w-fit" href="ms-windows-store://pdp/?ProductId=9WZDNCRFJ4Q7&mode=mini&cid=guest_desktop_upsell" data-tracking-client-ingraph data-tracking-control-name="pulse-article_windows-app-upsell_cta" data-tracking-will-navigate> Open the app </a> <button class="cta-modal__dismiss-btn absolute h-4 w-4 p-1 top-2 right-2 hover:cursor-pointer focus:outline focus:outline-2 focus:outline-color-action" data-tracking-control-name="pulse-article_windows-app-upsell_dismiss" aria-label="Dismiss"> <icon class="cta-modal__dismiss-icon block h-2 w-2 onload" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/adzjokfylbe8pvjr9h8iv96mw"></icon> </button> </div> </div> <code id="disableOneTapOnInit" style="display: none"><!--false--></code> <div class="main-container-desktop bg-color-canvas-tint text-color-text"> <code id="isGuest" style="display: none"><!--true--></code> <code id="isLite" style="display: none"><!--false--></code> <code id="isMobile" style="display: none"><!--false--></code> <code id="articleViewEventData" style="display: none"><!--"{\"articleId\":7263262585364333000,\"articleUrn\":\"urn:li:article:9075020838264861234\",\"authorId\":92742525,\"linkedInArticleUrn\":\"urn:li:linkedInArticle:7263262585364332544\"}"--></code> <code id="articleUrn" style="display: none"><!--"urn:li:linkedInArticle:7263262585364332544"--></code> <code id="legacyArticleUrn" style="display: none"><!--"urn:li:article:9075020838264861234"--></code> <div class="base-template bg-color-background-container flex flex-col min-h-[100vh] advice redesign x-article-base-page" data-test-is-split-layout-enabled> <a href="#base-template__workspace" class="skip-link btn-md btn-primary absolute z-11 -top-[100vh] focus:top-0"> Skip to main content </a> <header class="base-template__nav-container bg-color-background-container global-alert-offset sticky-header "> <nav class="nav pt-1.5 pb-2 flex items-center justify-between relative flex-nowrap babymamabear:py-1.5 nav--minified-mobile babybear:flex-wrap max-w-screen-content-max-w mx-auto babybear:px-mobile-container-padding" aria-label="Primary"> <a href="/?trk=article-ssr-frontend-x-article_nav-header-logo" class="nav__logo-link link-no-visited-state z-1 mr-auto min-h-[52px] flex items-center babybear:z-0 hover:no-underline focus:no-underline active:no-underline babymamabear:mr-3" data-tracking-control-name="article-ssr-frontend-x-article_nav-header-logo" data-tracking-will-navigate> <span class="sr-only">LinkedIn</span> <icon class="nav-logo--inbug flex text-color-brand papabear:hidden mamabear:hidden" data-svg-class-name="h-[34px] w-[34px] babybear:h-[26px] babybear:w-[26px]" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4zqr0f9jf98vi2nkijyc3bex2"></icon> <icon class="block text-color-brand w-[102px] h-[26px] babybear:hidden" data-test-id="nav-logo" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/8fkga714vy9b2wk5auqo5reeb"></icon> </a> <!----> <ul class="top-nav-menu flex items-center babybear:w-full babybear:justify-between babybear:pt-1 justify-start w-max pt-0 overflow-x-auto nav__menu babybear:order-last order-3 ml-auto"> <li class> <a href="https://www.linkedin.com/pulse/topics/home/?trk=article-ssr-frontend-x-article_guest_nav_menu_articles" data-tracking-control-name="article-ssr-frontend-x-article_guest_nav_menu_articles" data-tracking-will-navigate class="top-nav-link flex justify-center items-center min-h-[52px] hover:text-color-text visited:hover:text-color-text hover:no-underline w-8 flex-col mx-1 babybear:mx-0 text-color-text-secondary visited:text-color-text-secondary"> <icon class="top-nav-link__icon flex h-3 w-3 flex-shrink-0 justify-center " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/6ulnj3n2ijcmhej768y6oj1hr"> </icon> <span class="top-nav-link__label-text font-sans text-xs leading-regular text-center font-regular"> Articles </span> </a> </li> <li class> <a href="https://www.linkedin.com/pub/dir/+/+?trk=article-ssr-frontend-x-article_guest_nav_menu_people" data-tracking-control-name="article-ssr-frontend-x-article_guest_nav_menu_people" data-tracking-will-navigate class="top-nav-link flex justify-center items-center min-h-[52px] hover:text-color-text visited:hover:text-color-text hover:no-underline w-8 flex-col mx-1 babybear:mx-0 text-color-text-secondary visited:text-color-text-secondary"> <icon class="top-nav-link__icon flex h-3 w-3 flex-shrink-0 justify-center " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7kb6sn3tm4cx918cx9a5jlb0"> </icon> <span class="top-nav-link__label-text font-sans text-xs leading-regular text-center font-regular"> People </span> </a> </li> <li class> <a href="https://www.linkedin.com/learning/search?trk=article-ssr-frontend-x-article_guest_nav_menu_learning" data-tracking-control-name="article-ssr-frontend-x-article_guest_nav_menu_learning" data-tracking-will-navigate class="top-nav-link flex justify-center items-center min-h-[52px] hover:text-color-text visited:hover:text-color-text hover:no-underline w-8 flex-col mx-1 babybear:mx-0 text-color-text-secondary visited:text-color-text-secondary"> <icon class="top-nav-link__icon flex h-3 w-3 flex-shrink-0 justify-center " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/8wykgzgbqy0t3fnkgborvz54u"> </icon> <span class="top-nav-link__label-text font-sans text-xs leading-regular text-center font-regular"> Learning </span> </a> </li> <li class> <a href="https://www.linkedin.com/jobs/search?trk=article-ssr-frontend-x-article_guest_nav_menu_jobs" data-tracking-control-name="article-ssr-frontend-x-article_guest_nav_menu_jobs" data-tracking-will-navigate class="top-nav-link flex justify-center items-center min-h-[52px] hover:text-color-text visited:hover:text-color-text hover:no-underline w-8 flex-col mx-1 babybear:mx-0 text-color-text-secondary visited:text-color-text-secondary"> <icon class="top-nav-link__icon flex h-3 w-3 flex-shrink-0 justify-center " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/92eb1xekc34eklevj0io6x4ki"> </icon> <span class="top-nav-link__label-text font-sans text-xs leading-regular text-center font-regular"> Jobs </span> </a> </li> <li class> <a href="https://www.linkedin.com/games?trk=article-ssr-frontend-x-article_guest_nav_menu_games" data-tracking-control-name="article-ssr-frontend-x-article_guest_nav_menu_games" data-tracking-will-navigate class="top-nav-link flex justify-center items-center min-h-[52px] hover:text-color-text visited:hover:text-color-text hover:no-underline w-8 flex-col mx-1 babybear:mx-0 text-color-text-secondary visited:text-color-text-secondary"> <icon class="top-nav-link__icon flex h-3 w-3 flex-shrink-0 justify-center " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/29h8hsjuomfp50lam5ipnc3uh"> </icon> <span class="top-nav-link__label-text font-sans text-xs leading-regular text-center font-regular"> Games </span> </a> </li> <li class> <a href="ms-windows-store://pdp/?ProductId=9WZDNCRFJ4Q7&mode=mini&cid=guest_nav_upsell&trk=article-ssr-frontend-x-article_guest_nav_menu_windows" data-tracking-control-name="article-ssr-frontend-x-article_guest_nav_menu_windows" data-tracking-will-navigate class="top-nav-link flex justify-center items-center min-h-[52px] hover:text-color-text visited:hover:text-color-text hover:no-underline w-[96px] px-1 border-solid border-l-1 border-r-1 babybear:border-r-0 border-color-border-faint flex-col mx-1 babybear:mx-0 text-color-text-secondary visited:text-color-text-secondary"> <icon class="top-nav-link__icon flex h-3 w-3 flex-shrink-0 justify-center " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/admayac2rnonsqhz9v3rzwcyu"> </icon> <span class="top-nav-link__label-text font-sans text-xs leading-regular text-center font-regular"> Get the app </span> </a> </li> </ul> <div class="nav__cta-container order-3 flex gap-x-1 justify-end min-w-[100px] flex-nowrap flex-shrink-0 babybear:flex-wrap flex-2 babymamabear:min-w-[50px] "> <!----> <a class="nav__button-tertiary btn-md btn-tertiary" href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_nav-header-join" data-tracking-control-name="article-ssr-frontend-x-article_nav-header-join" data-test-live-nav-primary-cta data-tracking-will-navigate> Join now </a> <a class="nav__button-secondary btn-secondary-emphasis btn-md" href="https://www.linkedin.com/uas/login?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&fromSignIn=true&trk=article-ssr-frontend-x-article_nav-header-signin" data-tracking-control-name="article-ssr-frontend-x-article_nav-header-signin" data-tracking-will-navigate> Sign in </a> <a aria-label="Sign in" class="nav__link-person papabear:hidden mamabear:hidden" data-tracking-control-name="article-ssr-frontend-x-article_nav-header-signin" data-tracking-will-navigate href="https://www.linkedin.com/uas/login?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&fromSignIn=true&trk=article-ssr-frontend-x-article_nav-header-signin"> <img class="inline-block relative rounded-[50%] w-4 h-4 bg-color-entity-ghost-background" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt> </a> </div> <!----> <!----> </nav> </header> <!----> <div class="base-template__wrapper h-full w-full papabear:w-content-max-w papabear:flex papabear:mx-auto papamamabear:pt-desktop-content-top-margin babymamabear:px-mobile-container-padding grow "> <main id="base-template__workspace" class="base-template__workspace w-full "> <div class="absolute top-0 left-0 right-0 bottom-0 flex"> <!----> <div class="w-full lg:ml-3 xl:ml-6"> <div class="hidden h-full bg-color-surface-tint md:block md:w-[calc(37%-40px)] lg:w-[calc(37%-32px)]"></div> </div> <div class="bg-color-surface"></div> </div> <div class="lg:ml-3 xl:ml-6 mx-auto"> <!----> <code id="isGuest" style="display: none"><!--true--></code> <code id="memberUrn" style="display: none"><!--"urn:li:member:0"--></code> <code id="isNbaRecommendedArticlesDeeplinkEnabled" style="display: none"><!--"true"--></code> <code id="isDynamicTextareaEnabled" style="display: none"><!--"true"--></code> <article class="article-main relative flex-grow"> <section class="core-section-container my-3 relative"> <!----> <!----> <div class="core-section-container__content break-words"> <div class="article-segment" data-is-logged-in="false" data-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)" data-test-id="article-segment" data-total-count="18" data-tracking-prefix="article-ssr-frontend-x-article" role="presentation"> <div class="md:row pb-6 md:flex q-and-a-article article-content-row-reduced" data-test-q-and-a-article> <div class="column-article-segment-content md:column md:mb-8 md:flex md:w-2/5 md:justify-end"> <div class="h-fit md:pt-6"> <div class="article-segment-content-container md:box-content md:max-w-[392px] md:pr-1 lg:pr-4 xl:pr-8"> <div class="hidden md:block"> <!----> <div class="x-article-last-update-time text-sm leading-[24px] text-color-text-secondary"> Last updated on Nov 15, 2024 </div> <section class="mb-2"> <ol itemscope itemtype="http://schema.org/BreadcrumbList" class="breadcrumbs "> <li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem" class="breadcrumb inline-block mr-0.5 font-sans text-sm babybear:text-xs text-color-text after:content-['/'] after:text-color-text-low-emphasis after:ml-0.5 after:no-underline last:mr-0 last:after:hidden"> <a itemprop="item" class="breadcrumb__link inline-block link-no-visited-state !text-color-text-low-emphasis" href="https://www.linkedin.com/pulse/topics/home/" data-tracking-control-name="breadcrumb" data-tracking-will-navigate> <span class="font-normal" itemprop="name">All</span> </a> <meta itemprop="position" content="1"> </li> <li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem" class="breadcrumb inline-block mr-0.5 font-sans text-sm babybear:text-xs text-color-text after:content-['/'] after:text-color-text-low-emphasis after:ml-0.5 after:no-underline last:mr-0 last:after:hidden"> <a itemprop="item" class="breadcrumb__link inline-block link-no-visited-state !text-color-text-low-emphasis" href="https://www.linkedin.com/pulse/topics/engineering-s166/" data-tracking-control-name="breadcrumb" data-tracking-will-navigate> <span class="font-normal" itemprop="name">Engineering</span> </a> <meta itemprop="position" content="2"> </li> <li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem" class="breadcrumb inline-block mr-0.5 font-sans text-sm babybear:text-xs text-color-text after:content-['/'] after:text-color-text-low-emphasis after:ml-0.5 after:no-underline last:mr-0 last:after:hidden"> <a aria-current="page" itemprop="item" class="breadcrumb__link inline-block link-no-visited-state !text-color-text" href="https://www.linkedin.com/pulse/topics/engineering-s166/data-architecture-s18213/" data-tracking-control-name="breadcrumb" data-tracking-will-navigate> <span class="font-semibold" itemprop="name">Data Architecture</span> </a> <meta itemprop="position" content="3"> </li> </ol> </section> <h1 class="q-a-article-title text-display-md text-color-text font-bold w-11/12 text-[36px] " data-test-q-and-a-article-title> Struggling with data architecture performance issues? </h1> <div class="qa-redesign-article-content py-2 md:py-6" id="desktop-content-urn_li_articleSegment__urn_li_linkedInArticle_7263262585364332544_7263262586945585153_"> <div class="article-main__content" data-test-id="publishing-text-block"> <!----> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class>Experiencing performance hiccups in data architecture? You'll need a focused approach to address these challenges effectively:</span><!----> </p> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class> <ul> <li><span class="font-bold">Optimize indexing and queries:</span><span class> Regularly review and refine your database indexing and query structures to ensure efficient data retrieval.</span><!----></li> </ul> </span><!----> </p> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class> <ul> <li><span class="font-bold">Utilize caching mechanisms:</span><span class> Implement caching to reduce the load on your database and speed up data access times.</span><!----></li> </ul> </span><!----> </p> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class> <ul> <li><span class="font-bold">Monitor and scale resources:</span><span class> Continuously monitor performance metrics and scale your infrastructure as needed to handle growth.</span><!----></li> </ul> </span><!----> </p> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class>What strategies have worked for you in improving data architecture performance?</span><!----> </p> </div> </div> <div class="qa-redesign-article-content__components"> <div class="md:pb-2 pb-1 md:block hidden" data-test-qa-redesign-publisher-author-card> <div class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link publisher-author-card mb-4"> <a class="base-card__full-link absolute top-0 right-0 bottom-0 left-0 p-0 z-[2]" href="https://www.linkedin.com/showcase/skills-data-architecture/" data-tracking-control-name="article-ssr-frontend-x-article_publisher-author-card" data-tracking-will-navigate> <span class="sr-only"> Data Architecture </span> </a> <img class="inline-block relative w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/C4E0BAQHsVLSfXGFBpg/company-logo_100_100/company-logo_100_100/0/1674595242351?e=2147483647&v=beta&t=Ba7ImZODSb_D45g0tQVpfbkuLDk7uzWrwHwexS427x8" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/cs8pjfgyw96g44ln9r7tct85f" alt="Data Architecture"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full "> <!----> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> Data Architecture </h3> <!----> <!----> <div class="body-text text-color-text-low-emphasis base-main-card__metadata"> <!----> </div> <!----> </div> <div class="base-main-card__ctas z-[3] self-center ml-3 babybear:ml-1 babybear:self-start"> <a class="base-main-card__cta btn-sm btn-secondary" href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_publisher-author-card" data-tracking-control-name="article-ssr-frontend-x-article_publisher-author-card" data-tracking-will-navigate> + Follow </a> </div> </div> </div> </div> </div> </div> </div> </div> <div class="column-article-segment-contributions md:column md:pl-1 lg:pl-4 xl:pl-8 md:pb-[200px] md:flex md:w-3/5 md:justify-start"> <div class="md:box-content md:max-w-[576px]"> <div class="block md:hidden"> <!----> <div class="x-article-last-update-time text-sm leading-[24px] text-color-text-secondary"> Last updated on Nov 15, 2024 </div> <section class="mb-2"> <ol itemscope itemtype="http://schema.org/BreadcrumbList" class="breadcrumbs "> <li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem" class="breadcrumb inline-block mr-0.5 font-sans text-sm babybear:text-xs text-color-text after:content-['/'] after:text-color-text-low-emphasis after:ml-0.5 after:no-underline last:mr-0 last:after:hidden"> <a itemprop="item" class="breadcrumb__link inline-block link-no-visited-state !text-color-text-low-emphasis" href="https://www.linkedin.com/pulse/topics/home/" data-tracking-control-name="breadcrumb" data-tracking-will-navigate> <span class="font-normal" itemprop="name">All</span> </a> <meta itemprop="position" content="1"> </li> <li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem" class="breadcrumb inline-block mr-0.5 font-sans text-sm babybear:text-xs text-color-text after:content-['/'] after:text-color-text-low-emphasis after:ml-0.5 after:no-underline last:mr-0 last:after:hidden"> <a itemprop="item" class="breadcrumb__link inline-block link-no-visited-state !text-color-text-low-emphasis" href="https://www.linkedin.com/pulse/topics/engineering-s166/" data-tracking-control-name="breadcrumb" data-tracking-will-navigate> <span class="font-normal" itemprop="name">Engineering</span> </a> <meta itemprop="position" content="2"> </li> <li itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem" class="breadcrumb inline-block mr-0.5 font-sans text-sm babybear:text-xs text-color-text after:content-['/'] after:text-color-text-low-emphasis after:ml-0.5 after:no-underline last:mr-0 last:after:hidden"> <a aria-current="page" itemprop="item" class="breadcrumb__link inline-block link-no-visited-state !text-color-text" href="https://www.linkedin.com/pulse/topics/engineering-s166/data-architecture-s18213/" data-tracking-control-name="breadcrumb" data-tracking-will-navigate> <span class="font-semibold" itemprop="name">Data Architecture</span> </a> <meta itemprop="position" content="3"> </li> </ol> </section> <h1 class="q-a-article-title text-display-md text-color-text font-bold w-11/12 text-[32px] md:text-[40px] " data-test-q-and-a-article-title> Struggling with data architecture performance issues? </h1> </div> <div class="qa-redesign-article-content py-2 block md:hidden" id="mobile-content-urn_li_articleSegment__urn_li_linkedInArticle_7263262585364332544_7263262586945585153_"> <div class="article-main__content" data-test-id="publishing-text-block"> <!----> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class>Experiencing performance hiccups in data architecture? You'll need a focused approach to address these challenges effectively:</span><!----> </p> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class> <ul> <li><span class="font-bold">Optimize indexing and queries:</span><span class> Regularly review and refine your database indexing and query structures to ensure efficient data retrieval.</span><!----></li> </ul> </span><!----> </p> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class> <ul> <li><span class="font-bold">Utilize caching mechanisms:</span><span class> Implement caching to reduce the load on your database and speed up data access times.</span><!----></li> </ul> </span><!----> </p> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class> <ul> <li><span class="font-bold">Monitor and scale resources:</span><span class> Continuously monitor performance metrics and scale your infrastructure as needed to handle growth.</span><!----></li> </ul> </span><!----> </p> </div> <div class="article-main__content" data-test-id="publishing-text-block"> <p> <span class>What strategies have worked for you in improving data architecture performance?</span><!----> </p> </div> </div> <div data-test-qa-redesign-add-perspective class="article-segment-contributions-header-container sticky-on-scroll bg-color-canvas-tint md:ml-[-12px] md:pt-6 lg:ml-0 mt-1"> <!----> <div class="add-your-perspective-section relative flex flex-row items-center " data-segment-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)" data-test-add-contribution> <code id="add_your_perspective_tracking_prefix" style="display: none"><!--"article-ssr-frontend-x-article"--></code> <code id="isGuest" style="display: none"><!--true--></code> <code id="showFuseErrorMessage" style="display: none"><!--true--></code> <div class="mb-2"> <a class="add-your-perspective-button btn-sm flex flex-col items-start justify-center lg:btn-md bg-color-surface-accent-tint-1 hover:bg-color-container-tertiary-hover " href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article" target="_self" data-tracking-control-name="add_contribution_cta" data-tracking-will-navigate data-test-link data-test-add-contribution-btn aria-describedby="content-urn_li_articleSegment__urn_li_linkedInArticle_7263262585364332544_7263262586945585153_" data-test-contribution-cta-link-guest role="button"> <div data-test-contribution-btn-text class="add-your-perspective-button-text text-left text-color-text-low-emphasis">Add your perspective</div> <!----></a> </div> <div class="contribution-text-area-wrapper relative w-full hidden"> <code id="min_char_limit" style="display: none"><!--"125"--></code> <code id="min_reply_char_limit" style="display: none"><!--"1"--></code> <code id="max_char_limit" style="display: none"><!--"750"--></code> <code id="i18n_contribution_post_success" style="display: none"><!--"Contribution added successfully"--></code> <code id="i18n_contribution_post_error" style="display: none"><!--"Sorry, something went wrong while adding your contribution."--></code> <code id="i18n_contribution_edit_post_success" style="display: none"><!--"Contribution edited successfully"--></code> <code id="i18n_contribution_edit_post_error" style="display: none"><!--"Sorry, something went wrong while editing your contribution."--></code> <code id="i18n_try_refreshing_the_page" style="display: none"><!--"Try refreshing the page."--></code> <code id="i18n_characters" style="display: none"><!--"10 characters."--></code> <code id="i18n_characters_fraction" style="display: none"><!--"10/20 characters"--></code> <code id="i18n_contribution_post_rate_limit_error" style="display: none"><!--"It looks like you’ve already contributed a few times. To ensure diverse perspectives, we limit contributions."--></code> <code id="i18n_contribution_post_rate_limit_error_suggestion" style="display: none"><!--"Check out other articles"--></code> <div class="contribution-text-area-border ease-linear duration-300 mb-2 rounded-md border-1 border-solid border-[var(--color-input-container-border)] p-2 transition-all focus-within:shadow-border hover:shadow-border active:shadow-border-active md:px-3"> <textarea class="contribution-text-area leading-normal placeholder:text-color-input-hint box-border w-full resize-none border-0 bg-color-transparent p-0 text-md leading-open tracking-wide text-color-text outline-none placeholder:text-color-text-disabled lg:text-lg" placeholder="Some ways to get started: - One time at work… - In my experience… - One thing I’ve found helpful…" rows="4" data-segment-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)" aria-errormessage="error-urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)" data-feed-control="comment_box" data-feed-action-category="EXPAND" data-feed-action-type="expandContributionBox"></textarea> <div class="contribution-action-bar flex w-full items-center pt-2"> <span class="contribution-helper-text grow text-left text-xs text-color-text-secondary lg:text-sm" role="alert"> <span class="contribution-character-count"></span> <span class="contribution-error-message hidden text-color-signal-negative" id="error-urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)"> Help others by sharing more (125 characters min.) </span> </span> <button class="contribution-cancel-button ease-linear duration-300 btn-sm btn-tertiary mr-1 transition-all lg:btn-md" data-tracking-control-name="cancel_contribution"> Cancel </button> <button disabled="true" aria-disabled="true" class="submit-contribution-button ease-linear duration-300 btn-sm btn-primary transition-all lg:btn-md" data-tracking-control-name="comment_post" data-feed-control="comment_post" data-feed-action-category="COMMENT" data-feed-action-type="submitContribution"> <div class="loader flex"> <div class="loader__container mb-2 overflow-hidden"> <icon class="loader__icon inline-block loader__icon--default text-color-progress-loading" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/ddi43qwelxeqjxdd45pe3fvs1" data-svg-class-name="loader__icon-svg--x-small fill-currentColor h-[20px] min-h-[20px] w-[20px] min-w-[20px]"></icon> </div> </div> <span class="submit-contribution-button-text">Add</span> <span class="save-contribution-changes-button-text">Save</span> </button> </div> </div> </div> </div> </div> <div class> <div class="total-count flex items-center gap-0.5 md:px-1 pt-3 text-right text-md text-color-text font-bold" data-test-contributions-answers-count data-test-id="contributions-count" data-tracking-control-name="article-ssr-frontend-x-article_comments_count" data-feed-control="article-ssr-frontend-x-article_comments_count" data-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)"> <span class="total-count__count">18</span> answers </div> <code id="contributionSingular" style="display: none"><!--"\u003cspan class=\"total-count__count\"\u003e1\u003c/span\u003e answer"--></code> <code id="contributionPlural" style="display: none"><!--"\u003cspan class=\"total-count__count\"\u003e2\u003c/span\u003e answers"--></code> <ul class="contribution-list pt-3" data-test-qa-redesign-contribution-list> <li class="contribution" data-contribution-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265678479063420928)" data-contributor-urn="urn:li:member:895457155" data-is-logged-in="false"> <div class="flex items-center justify-between"> <a href="https://in.linkedin.com/in/im-nsk?trk=article-ssr-frontend-x-article" target="_blank" data-tracking-control-name="comment_actor" data-tracking-will-navigate class="contribution__lockup relative flex items-center overflow-hidden pr-1 font-sans hover:no-underline focus:no-underline xs:left-[-56px]"> <figure class="top-[4px] inline-flex lg:hidden"> <img class="inline-block relative rounded-[50%] w-4 h-4 " data-delayed-url="https://media.licdn.com/dms/image/v2/D5603AQGGRDG-vQjHiA/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1728883664795?e=2147483647&v=beta&t=COJ_DnFS2ALRGLtYo4E3gxblRArBkLnatGTm2S8h1D0" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <figure class="top-[4px] hidden lg:inline-flex"> <img class="inline-block relative rounded-[50%] w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/D5603AQGGRDG-vQjHiA/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1728883664795?e=2147483647&v=beta&t=COJ_DnFS2ALRGLtYo4E3gxblRArBkLnatGTm2S8h1D0" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <div class="min-w-0 ml-2"> <div class="flex items-center"> <span class="mr-0.5 truncate text-sm font-bold text-color-text lg:text-md"> Nishant Kumar </span> <!----><!----> </div> <p class="m-0 truncate text-sm text-color-text-low-emphasis md:text-md" data-test-id="contribution-lock-up-headline"> Writes to 25K+ | Data Engineer at IBM (Barclays) | Helping Job Seekers | Expert in SQL, Python, PySpark | AWS Certified | Databricks Certified | Open for Collaboration </p> </div> </a> <div class="flex items-center"> <!----> <div class="ellipsis-menu absolute right-0 top-0 contribution-control-menu relative" data-feed-action="show-comment-dropdown" data-id="comment__ellipsis-menu" data-feed-control="control_menu" data-tracking-control-name="comment_control_menu" data-feed-action-type="expandControl" data-feed-action-category="expand"> <div class="collapsible-dropdown flex items-center relative hyphens-auto"> <button class="ellipsis-menu__trigger collapsible-dropdown__button btn-md btn-tertiary cursor-pointer !py-[6px] !px-1 flex items-center rounded-[50%] ellipsis-menu__trigger--small w-[32px] h-[32px] flex justify-center w-[40px] min-w-[40px]" aria-expanded="false" aria-label="Open menu" data-tracking-control-name="article-ssr-frontend-x-article_ellipsis-menu-trigger" tabindex="0"> <icon class="ellipsis-menu__trigger-icon m-0 p-0 centered-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/c26vw8uiog92lvrqov98hvbxr"></icon> </button> <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-auto top-[100%]" role="menu" tabindex="-1"> <!----> <li class="ellipsis-menu__item flex contribution-control-menu-item--copy" data-feed-action="copyComment" data-feed-control="comment_control_menu_copy" data-tracking-control-name="comment_control_menu_copy" data-feed-action-type="controlMenuCopy" data-feed-action-category="copy" data-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265678479063420928)" data-comment-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)"> <button class="contribution-control-menu-item ellipsis-menu__item-button flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " data-tracking-control-name="comment_control_menu_copy" data-feed-action-category="expand" data-feed-action-type="expandCopyContribution" role="menuitem"> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/85z203x9ymzz8gu3a3jmtxy81"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Copy link to contribution</span> </button> </li> <li class="ellipsis-menu__item flex" data-feed-action="semaphoreComment" data-feed-control="comment_control_menu_report" data-tracking-control-name="comment_control_menu_report" data-feed-action-type="expandContributionReporting" data-feed-action-category="expand" data-test-id="contribution-control-menu-report"> <a href="/uas/login?session_redirect=https%3A%2F%2Fwww.linkedin.com%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=comment-semaphore-sign-in-redirect&guestReportContentType=AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION&_f=guest-reporting" data-tracking-control-name="comment-semaphore-sign-in-redirect" data-tracking-will-navigate data-item-type="semaphore" data-semaphore-content-type="AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION" data-semaphore-content-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265678479063420928)" data-semaphore-author-urn="urn:li:member:895457155" data-semaphore-tracking-prefix="comment-semaphore" data-is-logged-in="false" data-modal="semaphore__toggle" class="semaphore__toggle visited:text-color-text-secondary mx-0.25 flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " role="menuitem"> <!----> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/eo60762wicg7snl6mo020acft"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Report contribution</span> </a> <!----> <template id="comment-reported-card-template"> <p class="comment-reported-card bg-color-background-container p-2 text-sm font-medium text-color-text-secondary"> Thanks for letting us know! You'll no longer see this contribution</p> </template> </li> <!----><!----> </ul> <!----> </div> </div> <code id="contributionCopyLink" style="display: none"><!--"Link copied to clipboard"--></code> <code id="contributionCopyFail" style="display: none"><!--"Copy failed, try again later."--></code> <code id="contributionCopyUnsupported" style="display: none"><!--"Copy to clipboard is unsupported."--></code> </div> </div> <div class="contribution__container left__border -mb-2 -mt-1 animate-show ml-0 pl-0 md:ml-[-41px] md:pl-[32px] pr-0 lg:ml-[-33px] lg:pl-[40px] lg:pr-1 pt-2 pb-4"> <div class="flex flex-col justify-between lg:flex-col"> <div class="flex items-center justify-between gap-1"> </div> </div> <div class="contribution__text-wrapper relative"> <p class="contribution__text mb-1 whitespace-pre-wrap pt-1 text-md leading-open text-color-text md:mb-0 md:pt-0 line-clamp-5 lg:text-lg" data-tracking-control-name="comment_text">To enhance data architecture performance, I focus on three key areas: 1. Optimizing Indexes and Queries: I regularly analyze and refine indexes and query structures to reduce retrieval times and resource consumption. 2. Leveraging Caching: Caching frequently accessed data minimizes database load, significantly speeding up data access for users. 3. Monitoring and Scaling: I track performance metrics closely, allowing for timely resource scaling and adjustments to meet demand without compromising efficiency. This proactive approach has helped maintain a responsive, scalable, and efficient data architecture.</p> <button class="contribution__see-more-button absolute bottom-0 right-0 hidden cursor-pointer border-0 bg-color-surface p-0 text-md leading-open text-color-text-secondary hover:text-color-action hover:underline lg:text-lg" data-tracking-control-name="comment_expand" data-feed-control="comment_expand" data-feed-action-type="expandContributionText" data-feed-action-category="EXPAND" role="button" type="button">…see more</button> </div> <!----> <div class="contribution__social-action-bar relative right-1 flex flex-row items-center justify-start gap-1"> <div class="contribution-social-activity inline-flex items-center justify-start"> <code id="i18n_reaction_selection_state" style="display: none"><!--"%reactionType% %selectionState%"--></code> <div class="reactions-menu flex flex-row relative items-center justify-center select-none [-webkit-user-select:none] pointer-events-auto contribution-social-activity__reactions-menu " data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265678479063420928)" data-reactions-count="6"> <a class="reactions-menu__link text-color-text contribution-social-activity__button flex items-center btn-sm btn-tertiary justify-center sm:flex-row sm:text-sm rounded-sm px-0.5 relative h-6 cursor-pointer w-full contribution-social-activity__reactions-menu " href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_contribution-social-activity_like-cta" target="_blank" data-tracking-control-name="article-ssr-frontend-x-article_contribution-social-activity_reactions-cta" data-parent-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265678479063420928)" data-tracking-will-navigate data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265678479063420928)" data-reactions-count="6"> <!----> <div class="like-button-default flex flex-row items-center "> <icon class="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0" data-svg-class-name="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0--svg" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e2cf8dn8tvjcu9gl3qcxhw31q"> </icon> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> </a> </div> <template id="selected-reaction"> <div> <div class="selected-reaction--LIKE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Like" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7ze70iqo2l1rn7hwfoykiwjod"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> <div class="selected-reaction--PRAISE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Celebrate" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/czva5w81r4b0pjr7sh5r4nbw9"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Celebrate</span> </div> <div class="selected-reaction--APPRECIATION flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Support" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/8kvqqk9m1eu5ffqkdlum1ka1m"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Support</span> </div> <div class="selected-reaction--EMPATHY flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Love" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5yukss5d7kh4xrbd5642z6tk0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Love</span> </div> <div class="selected-reaction--INTEREST flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Insightful" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/es4dlamdpym2zbuhglwx2cuz0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Insightful</span> </div> <div class="selected-reaction--ENTERTAINMENT flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Funny" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0rqrq0h755yqqu59fy047ayt"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Funny</span> </div> </div> </template> <code id="i18n_reaction_singular" style="display: none"><!--"%numReactions% Reaction"--></code> <code id="i18n_reactions_plural" style="display: none"><!--"%numReactions% Reactions"--></code> <div class="flex items-center font-sans text-sm babybear:text-xs contribution-social-activity__social-actions before:middot flex items-center justify-start gap-1 pr-1 before:mx-0.5" data-sap-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265678479063420928)"> <div class="flex items-center font-normal text-color-text-low-emphasis no-underline visited:text-color-text-low-emphasis my-1" role="button" aria-label="6 Reactions" data-separate-ctas="false" data-test-id="social-actions__reactions" data-id="social-actions__reactions" data-num-reactions="6" data-singular="%numReactions%" data-plural="%numReactions%" data-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265678479063420928)" tabindex="0"> <img alt data-reaction-type="EMPATHY" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/37hg81qnm85dsy5mbqfifg9qs" height="16px" width="16px"> <img alt data-reaction-type="LIKE" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur" height="16px" width="16px"> <img alt data-reaction-type="INTEREST" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4v7dh2d6cuqm24mzps1pqzeqt" height="16px" width="16px"> <span aria-hidden="true" class="font-normal ml-0.5" data-test-id="social-actions__reaction-count"> 6 </span> </div> <code id="social-actions__reaction-image-APPRECIATION" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cib97epu77mrzque5gqlzjgaw"--></code> <!----><!----> <code id="social-actions__reaction-image-EMPATHY" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/37hg81qnm85dsy5mbqfifg9qs"--></code> <code id="social-actions__reaction-image-ENTERTAINMENT" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/e7ppwfmo0if15fgie4q5r4us4"--></code> <!----> <code id="social-actions__reaction-image-INTEREST" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4v7dh2d6cuqm24mzps1pqzeqt"--></code> <code id="social-actions__reaction-image-LIKE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur"--></code> <code id="social-actions__reaction-image-MAYBE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4iy169rwfs5rdhspekg2r5wc6"--></code> <code id="social-actions__reaction-image-PRAISE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cjrxeu0ese8oxe32kiom8kzoh"--></code> <!----><!----><!----><!----> </div> </div> <!----> </div> <!----><!----> </div> <!----><!----><!----> </li> <li class="contribution" data-contribution-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265804255498825728)" data-contributor-urn="urn:li:member:774945923" data-is-logged-in="false"> <div class="flex items-center justify-between"> <a href="https://br.linkedin.com/in/pablo-guimar%C3%A3es-%E2%98%81-0ab640197?trk=article-ssr-frontend-x-article" target="_blank" data-tracking-control-name="comment_actor" data-tracking-will-navigate class="contribution__lockup relative flex items-center overflow-hidden pr-1 font-sans hover:no-underline focus:no-underline xs:left-[-56px]"> <figure class="top-[4px] inline-flex lg:hidden"> <img class="inline-block relative rounded-[50%] w-4 h-4 " data-delayed-url="https://media.licdn.com/dms/image/v2/C4E03AQHFG6AXG9K0oQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1635205914377?e=2147483647&v=beta&t=3Hvk4PuGnQL_sHQasSwYNU5CvnOH_7dojA5f-WyvslY" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <figure class="top-[4px] hidden lg:inline-flex"> <img class="inline-block relative rounded-[50%] w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/C4E03AQHFG6AXG9K0oQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1635205914377?e=2147483647&v=beta&t=3Hvk4PuGnQL_sHQasSwYNU5CvnOH_7dojA5f-WyvslY" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <div class="min-w-0 ml-2"> <div class="flex items-center"> <span class="mr-0.5 truncate text-sm font-bold text-color-text lg:text-md"> Pablo Guimarães ☁ </span> <!----><!----> </div> <p class="m-0 truncate text-sm text-color-text-low-emphasis md:text-md" data-test-id="contribution-lock-up-headline"> Enterprise Architect | Tech Influencer | Founder Big Data Developers Community | Cloud Data Strategy </p> </div> </a> <div class="flex items-center"> <!----> <div class="ellipsis-menu absolute right-0 top-0 contribution-control-menu relative" data-feed-action="show-comment-dropdown" data-id="comment__ellipsis-menu" data-feed-control="control_menu" data-tracking-control-name="comment_control_menu" data-feed-action-type="expandControl" data-feed-action-category="expand"> <div class="collapsible-dropdown flex items-center relative hyphens-auto"> <button class="ellipsis-menu__trigger collapsible-dropdown__button btn-md btn-tertiary cursor-pointer !py-[6px] !px-1 flex items-center rounded-[50%] ellipsis-menu__trigger--small w-[32px] h-[32px] flex justify-center w-[40px] min-w-[40px]" aria-expanded="false" aria-label="Open menu" data-tracking-control-name="article-ssr-frontend-x-article_ellipsis-menu-trigger" tabindex="0"> <icon class="ellipsis-menu__trigger-icon m-0 p-0 centered-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/c26vw8uiog92lvrqov98hvbxr"></icon> </button> <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-auto top-[100%]" role="menu" tabindex="-1"> <!----> <li class="ellipsis-menu__item flex contribution-control-menu-item--copy" data-feed-action="copyComment" data-feed-control="comment_control_menu_copy" data-tracking-control-name="comment_control_menu_copy" data-feed-action-type="controlMenuCopy" data-feed-action-category="copy" data-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265804255498825728)" data-comment-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)"> <button class="contribution-control-menu-item ellipsis-menu__item-button flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " data-tracking-control-name="comment_control_menu_copy" data-feed-action-category="expand" data-feed-action-type="expandCopyContribution" role="menuitem"> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/85z203x9ymzz8gu3a3jmtxy81"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Copy link to contribution</span> </button> </li> <li class="ellipsis-menu__item flex" data-feed-action="semaphoreComment" data-feed-control="comment_control_menu_report" data-tracking-control-name="comment_control_menu_report" data-feed-action-type="expandContributionReporting" data-feed-action-category="expand" data-test-id="contribution-control-menu-report"> <a href="/uas/login?session_redirect=https%3A%2F%2Fwww.linkedin.com%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=comment-semaphore-sign-in-redirect&guestReportContentType=AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION&_f=guest-reporting" data-tracking-control-name="comment-semaphore-sign-in-redirect" data-tracking-will-navigate data-item-type="semaphore" data-semaphore-content-type="AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION" data-semaphore-content-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265804255498825728)" data-semaphore-author-urn="urn:li:member:774945923" data-semaphore-tracking-prefix="comment-semaphore" data-is-logged-in="false" data-modal="semaphore__toggle" class="semaphore__toggle visited:text-color-text-secondary mx-0.25 flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " role="menuitem"> <!----> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/eo60762wicg7snl6mo020acft"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Report contribution</span> </a> <!----> <template id="comment-reported-card-template"> <p class="comment-reported-card bg-color-background-container p-2 text-sm font-medium text-color-text-secondary"> Thanks for letting us know! You'll no longer see this contribution</p> </template> </li> <!----><!----> </ul> <!----> </div> </div> <code id="contributionCopyLink" style="display: none"><!--"Link copied to clipboard"--></code> <code id="contributionCopyFail" style="display: none"><!--"Copy failed, try again later."--></code> <code id="contributionCopyUnsupported" style="display: none"><!--"Copy to clipboard is unsupported."--></code> </div> </div> <div class="contribution__container left__border -mb-2 -mt-1 animate-show ml-0 pl-0 md:ml-[-41px] md:pl-[32px] pr-0 lg:ml-[-33px] lg:pl-[40px] lg:pr-1 pt-2 pb-4"> <div class="flex flex-col justify-between lg:flex-col"> <div class="flex items-center justify-between gap-1"> </div> </div> <div class="contribution__text-wrapper relative"> <p class="contribution__text mb-1 whitespace-pre-wrap pt-1 text-md leading-open text-color-text md:mb-0 md:pt-0 line-clamp-5 lg:text-lg" data-tracking-control-name="comment_text">Problemas de performance em arquiteturas de dados podem ser causados por designs inadequados, pipelines ineficientes ou governança fraca. Para mitigar, normalize fluxos ETL, use particionamento de dados e indexação apropriada. Adote processamento paralelo com ferramentas como Apache Spark e otimize queries SQL. Invista em monitoramento contínuo via observabilidade (Prometheus/Grafana) e ajuste parâmetros do banco (cache, threads). Escolha arquiteturas escaláveis, como microserviços, e garanta pipelines ágeis com ferramentas CI/CD.</p> <button class="contribution__see-more-button absolute bottom-0 right-0 hidden cursor-pointer border-0 bg-color-surface p-0 text-md leading-open text-color-text-secondary hover:text-color-action hover:underline lg:text-lg" data-tracking-control-name="comment_expand" data-feed-control="comment_expand" data-feed-action-type="expandContributionText" data-feed-action-category="EXPAND" role="button" type="button">…see more</button> </div> <div data-tracking-control-name="x_article_on_demand_translation_buttons" class="translation-buttons-container"> <div class="translation-status after:middot my-1 -mr-1.5 inline-flex hidden items-center justify-start gap-1 text-sm text-color-text-secondary"> Translated </div> <button class="show-translation-button btn-sm btn-tertiary-emphasis my-1 -ml-2" data-tracking-control-name="show_translated_contribution"> Show translation </button> <button class="show-original-button btn-sm btn-tertiary-emphasis my-1 hidden" data-tracking-control-name="show_original_contribution"> Show original </button> <code id="sourceLocale" style="display: none"><!--{"primaryLocale":{"country":"BR","language":"pt"}}--></code> <code id="targetLocale" style="display: none"><!--"en"--></code> <code id="contributionTranslationFail" style="display: none"><!--"Sorry, this translation is unavailable. Try refreshing the page."--></code> <code id="contributionTranslationLoading" style="display: none"><!--"Translating…"--></code> <code id="contributionTranslated" style="display: none"><!--"Translated"--></code> </div> <div class="contribution__social-action-bar relative right-1 flex flex-row items-center justify-start gap-1"> <div class="contribution-social-activity inline-flex items-center justify-start"> <code id="i18n_reaction_selection_state" style="display: none"><!--"%reactionType% %selectionState%"--></code> <div class="reactions-menu flex flex-row relative items-center justify-center select-none [-webkit-user-select:none] pointer-events-auto contribution-social-activity__reactions-menu " data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265804255498825728)" data-reactions-count="4"> <a class="reactions-menu__link text-color-text contribution-social-activity__button flex items-center btn-sm btn-tertiary justify-center sm:flex-row sm:text-sm rounded-sm px-0.5 relative h-6 cursor-pointer w-full contribution-social-activity__reactions-menu " href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_contribution-social-activity_like-cta" target="_blank" data-tracking-control-name="article-ssr-frontend-x-article_contribution-social-activity_reactions-cta" data-parent-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265804255498825728)" data-tracking-will-navigate data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265804255498825728)" data-reactions-count="4"> <!----> <div class="like-button-default flex flex-row items-center "> <icon class="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0" data-svg-class-name="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0--svg" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e2cf8dn8tvjcu9gl3qcxhw31q"> </icon> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> </a> </div> <template id="selected-reaction"> <div> <div class="selected-reaction--LIKE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Like" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7ze70iqo2l1rn7hwfoykiwjod"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> <div class="selected-reaction--PRAISE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Celebrate" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/czva5w81r4b0pjr7sh5r4nbw9"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Celebrate</span> </div> <div class="selected-reaction--APPRECIATION flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Support" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/8kvqqk9m1eu5ffqkdlum1ka1m"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Support</span> </div> <div class="selected-reaction--EMPATHY flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Love" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5yukss5d7kh4xrbd5642z6tk0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Love</span> </div> <div class="selected-reaction--INTEREST flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Insightful" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/es4dlamdpym2zbuhglwx2cuz0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Insightful</span> </div> <div class="selected-reaction--ENTERTAINMENT flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Funny" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0rqrq0h755yqqu59fy047ayt"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Funny</span> </div> </div> </template> <code id="i18n_reaction_singular" style="display: none"><!--"%numReactions% Reaction"--></code> <code id="i18n_reactions_plural" style="display: none"><!--"%numReactions% Reactions"--></code> <div class="flex items-center font-sans text-sm babybear:text-xs contribution-social-activity__social-actions before:middot flex items-center justify-start gap-1 pr-1 before:mx-0.5" data-sap-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265804255498825728)"> <div class="flex items-center font-normal text-color-text-low-emphasis no-underline visited:text-color-text-low-emphasis my-1" role="button" aria-label="4 Reactions" data-separate-ctas="false" data-test-id="social-actions__reactions" data-id="social-actions__reactions" data-num-reactions="4" data-singular="%numReactions%" data-plural="%numReactions%" data-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265804255498825728)" tabindex="0"> <img alt data-reaction-type="LIKE" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur" height="16px" width="16px"> <span aria-hidden="true" class="font-normal ml-0.5" data-test-id="social-actions__reaction-count"> 4 </span> </div> <code id="social-actions__reaction-image-APPRECIATION" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cib97epu77mrzque5gqlzjgaw"--></code> <!----><!----> <code id="social-actions__reaction-image-EMPATHY" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/37hg81qnm85dsy5mbqfifg9qs"--></code> <code id="social-actions__reaction-image-ENTERTAINMENT" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/e7ppwfmo0if15fgie4q5r4us4"--></code> <!----> <code id="social-actions__reaction-image-INTEREST" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4v7dh2d6cuqm24mzps1pqzeqt"--></code> <code id="social-actions__reaction-image-LIKE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur"--></code> <code id="social-actions__reaction-image-MAYBE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4iy169rwfs5rdhspekg2r5wc6"--></code> <code id="social-actions__reaction-image-PRAISE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cjrxeu0ese8oxe32kiom8kzoh"--></code> <!----><!----><!----><!----> </div> </div> <!----> </div> <!----><!----> </div> <!----><!----><!----> </li> <li class="contribution" data-contribution-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7263525691101474816)" data-contributor-urn="urn:li:member:6028310" data-is-logged-in="false"> <div class="flex items-center justify-between"> <a href="https://be.linkedin.com/in/nadeemmalikbe?trk=article-ssr-frontend-x-article" target="_blank" data-tracking-control-name="comment_actor" data-tracking-will-navigate class="contribution__lockup relative flex items-center overflow-hidden pr-1 font-sans hover:no-underline focus:no-underline xs:left-[-56px]"> <figure class="top-[4px] inline-flex lg:hidden"> <img class="inline-block relative rounded-[50%] w-4 h-4 " data-delayed-url="https://media.licdn.com/dms/image/v2/D4E03AQEZ_aGM0d0hfg/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1704199397005?e=2147483647&v=beta&t=viI32xhOoSJxq9jdeUhyL7Lp0YHfbdYrHTWXudw_jvw" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <figure class="top-[4px] hidden lg:inline-flex"> <img class="inline-block relative rounded-[50%] w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/D4E03AQEZ_aGM0d0hfg/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1704199397005?e=2147483647&v=beta&t=viI32xhOoSJxq9jdeUhyL7Lp0YHfbdYrHTWXudw_jvw" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <div class="min-w-0 ml-2"> <div class="flex items-center"> <span class="mr-0.5 truncate text-sm font-bold text-color-text lg:text-md"> Nadeem Malik </span> <!----><!----> </div> <p class="m-0 truncate text-sm text-color-text-low-emphasis md:text-md" data-test-id="contribution-lock-up-headline"> Enterprise Architect - providing enterprise-wide insights, promoting standardization, reducing costs, mitigating risk, increasing agility, realizing strategies, and driving innovation. </p> </div> </a> <div class="flex items-center"> <!----> <div class="ellipsis-menu absolute right-0 top-0 contribution-control-menu relative" data-feed-action="show-comment-dropdown" data-id="comment__ellipsis-menu" data-feed-control="control_menu" data-tracking-control-name="comment_control_menu" data-feed-action-type="expandControl" data-feed-action-category="expand"> <div class="collapsible-dropdown flex items-center relative hyphens-auto"> <button class="ellipsis-menu__trigger collapsible-dropdown__button btn-md btn-tertiary cursor-pointer !py-[6px] !px-1 flex items-center rounded-[50%] ellipsis-menu__trigger--small w-[32px] h-[32px] flex justify-center w-[40px] min-w-[40px]" aria-expanded="false" aria-label="Open menu" data-tracking-control-name="article-ssr-frontend-x-article_ellipsis-menu-trigger" tabindex="0"> <icon class="ellipsis-menu__trigger-icon m-0 p-0 centered-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/c26vw8uiog92lvrqov98hvbxr"></icon> </button> <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-auto top-[100%]" role="menu" tabindex="-1"> <!----> <li class="ellipsis-menu__item flex contribution-control-menu-item--copy" data-feed-action="copyComment" data-feed-control="comment_control_menu_copy" data-tracking-control-name="comment_control_menu_copy" data-feed-action-type="controlMenuCopy" data-feed-action-category="copy" data-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7263525691101474816)" data-comment-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)"> <button class="contribution-control-menu-item ellipsis-menu__item-button flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " data-tracking-control-name="comment_control_menu_copy" data-feed-action-category="expand" data-feed-action-type="expandCopyContribution" role="menuitem"> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/85z203x9ymzz8gu3a3jmtxy81"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Copy link to contribution</span> </button> </li> <li class="ellipsis-menu__item flex" data-feed-action="semaphoreComment" data-feed-control="comment_control_menu_report" data-tracking-control-name="comment_control_menu_report" data-feed-action-type="expandContributionReporting" data-feed-action-category="expand" data-test-id="contribution-control-menu-report"> <a href="/uas/login?session_redirect=https%3A%2F%2Fwww.linkedin.com%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=comment-semaphore-sign-in-redirect&guestReportContentType=AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION&_f=guest-reporting" data-tracking-control-name="comment-semaphore-sign-in-redirect" data-tracking-will-navigate data-item-type="semaphore" data-semaphore-content-type="AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION" data-semaphore-content-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7263525691101474816)" data-semaphore-author-urn="urn:li:member:6028310" data-semaphore-tracking-prefix="comment-semaphore" data-is-logged-in="false" data-modal="semaphore__toggle" class="semaphore__toggle visited:text-color-text-secondary mx-0.25 flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " role="menuitem"> <!----> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/eo60762wicg7snl6mo020acft"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Report contribution</span> </a> <!----> <template id="comment-reported-card-template"> <p class="comment-reported-card bg-color-background-container p-2 text-sm font-medium text-color-text-secondary"> Thanks for letting us know! You'll no longer see this contribution</p> </template> </li> <!----><!----> </ul> <!----> </div> </div> <code id="contributionCopyLink" style="display: none"><!--"Link copied to clipboard"--></code> <code id="contributionCopyFail" style="display: none"><!--"Copy failed, try again later."--></code> <code id="contributionCopyUnsupported" style="display: none"><!--"Copy to clipboard is unsupported."--></code> </div> </div> <div class="contribution__container left__border -mb-2 -mt-1 animate-show ml-0 pl-0 md:ml-[-41px] md:pl-[32px] pr-0 lg:ml-[-33px] lg:pl-[40px] lg:pr-1 pt-2 pb-4"> <div class="flex flex-col justify-between lg:flex-col"> <div class="flex items-center justify-between gap-1"> </div> </div> <div class="contribution__text-wrapper relative"> <p class="contribution__text mb-1 whitespace-pre-wrap pt-1 text-md leading-open text-color-text md:mb-0 md:pt-0 line-clamp-5 lg:text-lg" data-tracking-control-name="comment_text">Think of database optimization like city traffic management - indexes are your road signs, caching your local distribution centers, and scaling your dynamic lane management. While these fundamentals remain crucial, I've seen teams overlook query pattern analysis and workload characterization. Modern observability tools + structured performance testing reveal that most bottlenecks stem from access patterns rather than raw capacity. Anyone exploring columnar storage + materialized views for read-heavy workflows? #DataArchitecture #Performance</p> <button class="contribution__see-more-button absolute bottom-0 right-0 hidden cursor-pointer border-0 bg-color-surface p-0 text-md leading-open text-color-text-secondary hover:text-color-action hover:underline lg:text-lg" data-tracking-control-name="comment_expand" data-feed-control="comment_expand" data-feed-action-type="expandContributionText" data-feed-action-category="EXPAND" role="button" type="button">…see more</button> </div> <!----> <div class="contribution__social-action-bar relative right-1 flex flex-row items-center justify-start gap-1"> <div class="contribution-social-activity inline-flex items-center justify-start"> <code id="i18n_reaction_selection_state" style="display: none"><!--"%reactionType% %selectionState%"--></code> <div class="reactions-menu flex flex-row relative items-center justify-center select-none [-webkit-user-select:none] pointer-events-auto contribution-social-activity__reactions-menu " data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7263525691101474816)" data-reactions-count="3"> <a class="reactions-menu__link text-color-text contribution-social-activity__button flex items-center btn-sm btn-tertiary justify-center sm:flex-row sm:text-sm rounded-sm px-0.5 relative h-6 cursor-pointer w-full contribution-social-activity__reactions-menu " href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_contribution-social-activity_like-cta" target="_blank" data-tracking-control-name="article-ssr-frontend-x-article_contribution-social-activity_reactions-cta" data-parent-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7263525691101474816)" data-tracking-will-navigate data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7263525691101474816)" data-reactions-count="3"> <!----> <div class="like-button-default flex flex-row items-center "> <icon class="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0" data-svg-class-name="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0--svg" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e2cf8dn8tvjcu9gl3qcxhw31q"> </icon> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> </a> </div> <template id="selected-reaction"> <div> <div class="selected-reaction--LIKE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Like" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7ze70iqo2l1rn7hwfoykiwjod"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> <div class="selected-reaction--PRAISE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Celebrate" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/czva5w81r4b0pjr7sh5r4nbw9"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Celebrate</span> </div> <div class="selected-reaction--APPRECIATION flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Support" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/8kvqqk9m1eu5ffqkdlum1ka1m"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Support</span> </div> <div class="selected-reaction--EMPATHY flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Love" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5yukss5d7kh4xrbd5642z6tk0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Love</span> </div> <div class="selected-reaction--INTEREST flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Insightful" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/es4dlamdpym2zbuhglwx2cuz0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Insightful</span> </div> <div class="selected-reaction--ENTERTAINMENT flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Funny" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0rqrq0h755yqqu59fy047ayt"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Funny</span> </div> </div> </template> <code id="i18n_reaction_singular" style="display: none"><!--"%numReactions% Reaction"--></code> <code id="i18n_reactions_plural" style="display: none"><!--"%numReactions% Reactions"--></code> <div class="flex items-center font-sans text-sm babybear:text-xs contribution-social-activity__social-actions before:middot flex items-center justify-start gap-1 pr-1 before:mx-0.5" data-sap-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7263525691101474816)"> <div class="flex items-center font-normal text-color-text-low-emphasis no-underline visited:text-color-text-low-emphasis my-1" role="button" aria-label="3 Reactions" data-separate-ctas="false" data-test-id="social-actions__reactions" data-id="social-actions__reactions" data-num-reactions="3" data-singular="%numReactions%" data-plural="%numReactions%" data-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7263525691101474816)" tabindex="0"> <img alt data-reaction-type="LIKE" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur" height="16px" width="16px"> <span aria-hidden="true" class="font-normal ml-0.5" data-test-id="social-actions__reaction-count"> 3 </span> </div> <code id="social-actions__reaction-image-APPRECIATION" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cib97epu77mrzque5gqlzjgaw"--></code> <!----><!----> <code id="social-actions__reaction-image-EMPATHY" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/37hg81qnm85dsy5mbqfifg9qs"--></code> <code id="social-actions__reaction-image-ENTERTAINMENT" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/e7ppwfmo0if15fgie4q5r4us4"--></code> <!----> <code id="social-actions__reaction-image-INTEREST" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4v7dh2d6cuqm24mzps1pqzeqt"--></code> <code id="social-actions__reaction-image-LIKE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur"--></code> <code id="social-actions__reaction-image-MAYBE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4iy169rwfs5rdhspekg2r5wc6"--></code> <code id="social-actions__reaction-image-PRAISE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cjrxeu0ese8oxe32kiom8kzoh"--></code> <!----><!----><!----><!----> </div> </div> <!----> </div> <!----><!----> </div> <!----><!----><!----> </li> <li class="contribution" data-contribution-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265914844875268096)" data-contributor-urn="urn:li:member:197255741" data-contribution-tracking-id="z28Nx3+T7RfM7ld2aSRKkg==" data-is-logged-in="false"> <div class="flex items-center justify-between"> <a href="https://pk.linkedin.com/in/kumail-raza-76508856?trk=article-ssr-frontend-x-article" target="_blank" data-tracking-control-name="comment_actor" data-tracking-will-navigate class="contribution__lockup relative flex items-center overflow-hidden pr-1 font-sans hover:no-underline focus:no-underline xs:left-[-56px]"> <figure class="top-[4px] inline-flex lg:hidden"> <img class="inline-block relative rounded-[50%] w-4 h-4 " data-delayed-url="https://media.licdn.com/dms/image/v2/C4E03AQFQOJnoC3rRZw/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1577212979669?e=2147483647&v=beta&t=MmGo0E_uPuvATDPZBUhVb5HoyN9jG-ObM4tEZ9a7jTw" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <figure class="top-[4px] hidden lg:inline-flex"> <img class="inline-block relative rounded-[50%] w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/C4E03AQFQOJnoC3rRZw/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1577212979669?e=2147483647&v=beta&t=MmGo0E_uPuvATDPZBUhVb5HoyN9jG-ObM4tEZ9a7jTw" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <div class="min-w-0 ml-2"> <div class="flex items-center"> <span class="mr-0.5 truncate text-sm font-bold text-color-text lg:text-md"> Kumail Raza </span> <!----><!----> </div> <p class="m-0 truncate text-sm text-color-text-low-emphasis md:text-md" data-test-id="contribution-lock-up-headline"> Principal Consultant | Data Solution Architect | Associate AI Engineer </p> </div> </a> <div class="flex items-center"> <!----> <div class="ellipsis-menu absolute right-0 top-0 contribution-control-menu relative" data-feed-action="show-comment-dropdown" data-id="comment__ellipsis-menu" data-feed-control="control_menu" data-tracking-control-name="comment_control_menu" data-feed-action-type="expandControl" data-feed-action-category="expand"> <div class="collapsible-dropdown flex items-center relative hyphens-auto"> <button class="ellipsis-menu__trigger collapsible-dropdown__button btn-md btn-tertiary cursor-pointer !py-[6px] !px-1 flex items-center rounded-[50%] ellipsis-menu__trigger--small w-[32px] h-[32px] flex justify-center w-[40px] min-w-[40px]" aria-expanded="false" aria-label="Open menu" data-tracking-control-name="article-ssr-frontend-x-article_ellipsis-menu-trigger" tabindex="0"> <icon class="ellipsis-menu__trigger-icon m-0 p-0 centered-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/c26vw8uiog92lvrqov98hvbxr"></icon> </button> <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-auto top-[100%]" role="menu" tabindex="-1"> <!----> <li class="ellipsis-menu__item flex contribution-control-menu-item--copy" data-feed-action="copyComment" data-feed-control="comment_control_menu_copy" data-tracking-control-name="comment_control_menu_copy" data-feed-action-type="controlMenuCopy" data-feed-action-category="copy" data-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265914844875268096)" data-comment-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)"> <button class="contribution-control-menu-item ellipsis-menu__item-button flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " data-tracking-control-name="comment_control_menu_copy" data-feed-action-category="expand" data-feed-action-type="expandCopyContribution" role="menuitem"> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/85z203x9ymzz8gu3a3jmtxy81"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Copy link to contribution</span> </button> </li> <li class="ellipsis-menu__item flex" data-feed-action="semaphoreComment" data-feed-control="comment_control_menu_report" data-tracking-control-name="comment_control_menu_report" data-feed-action-type="expandContributionReporting" data-feed-action-category="expand" data-test-id="contribution-control-menu-report"> <a href="/uas/login?session_redirect=https%3A%2F%2Fwww.linkedin.com%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=comment-semaphore-sign-in-redirect&guestReportContentType=AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION&_f=guest-reporting" data-tracking-control-name="comment-semaphore-sign-in-redirect" data-tracking-will-navigate data-item-type="semaphore" data-semaphore-content-type="AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION" data-semaphore-content-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265914844875268096)" data-semaphore-author-urn="urn:li:member:197255741" data-semaphore-tracking-prefix="comment-semaphore" data-is-logged-in="false" data-modal="semaphore__toggle" class="semaphore__toggle visited:text-color-text-secondary mx-0.25 flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " role="menuitem"> <!----> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/eo60762wicg7snl6mo020acft"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Report contribution</span> </a> <!----> <template id="comment-reported-card-template"> <p class="comment-reported-card bg-color-background-container p-2 text-sm font-medium text-color-text-secondary"> Thanks for letting us know! You'll no longer see this contribution</p> </template> </li> <!----><!----> </ul> <!----> </div> </div> <code id="contributionCopyLink" style="display: none"><!--"Link copied to clipboard"--></code> <code id="contributionCopyFail" style="display: none"><!--"Copy failed, try again later."--></code> <code id="contributionCopyUnsupported" style="display: none"><!--"Copy to clipboard is unsupported."--></code> </div> </div> <div class="contribution__container left__border -mb-2 -mt-1 animate-show ml-0 pl-0 md:ml-[-41px] md:pl-[32px] pr-0 lg:ml-[-33px] lg:pl-[40px] lg:pr-1 pt-2 pb-4"> <div class="flex flex-col justify-between lg:flex-col"> <div class="flex items-center justify-between gap-1"> </div> </div> <div class="contribution__text-wrapper relative"> <p class="contribution__text mb-1 whitespace-pre-wrap pt-1 text-md leading-open text-color-text md:mb-0 md:pt-0 line-clamp-5 lg:text-lg" data-tracking-control-name="comment_text">Key Strategies for Addressing Data Architecture and Performance Issues: Identify Root Cause: Analyze performance bottlenecks (slow queries). Assess data quality issues (inconsistencies, duplication). Review data model for optimization opportunities. Improve Query Performance: Implement query optimization techniques. Consider stored procedures or materialized views for complex queries. Tune database configuration parameters (buffer pool size, connection pool size). Implement Data Governance: Establish data quality standards and validation processes. Protect sensitive data with security measures (access controls). Leverage Cloud Technologies: Utilize serverless computing for automatic scaling. Employ cloud-based data warehouses</p> <button class="contribution__see-more-button absolute bottom-0 right-0 hidden cursor-pointer border-0 bg-color-surface p-0 text-md leading-open text-color-text-secondary hover:text-color-action hover:underline lg:text-lg" data-tracking-control-name="comment_expand" data-feed-control="comment_expand" data-feed-action-type="expandContributionText" data-feed-action-category="EXPAND" role="button" type="button">…see more</button> </div> <!----> <div class="contribution__social-action-bar relative right-1 flex flex-row items-center justify-start gap-1"> <div class="contribution-social-activity inline-flex items-center justify-start"> <code id="i18n_reaction_selection_state" style="display: none"><!--"%reactionType% %selectionState%"--></code> <div class="reactions-menu flex flex-row relative items-center justify-center select-none [-webkit-user-select:none] pointer-events-auto contribution-social-activity__reactions-menu " data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265914844875268096)" data-reactions-count="2"> <a class="reactions-menu__link text-color-text contribution-social-activity__button flex items-center btn-sm btn-tertiary justify-center sm:flex-row sm:text-sm rounded-sm px-0.5 relative h-6 cursor-pointer w-full contribution-social-activity__reactions-menu " href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_contribution-social-activity_like-cta" target="_blank" data-tracking-control-name="article-ssr-frontend-x-article_contribution-social-activity_reactions-cta" data-parent-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265914844875268096)" data-tracking-will-navigate data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265914844875268096)" data-reactions-count="2"> <!----> <div class="like-button-default flex flex-row items-center "> <icon class="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0" data-svg-class-name="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0--svg" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e2cf8dn8tvjcu9gl3qcxhw31q"> </icon> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> </a> </div> <template id="selected-reaction"> <div> <div class="selected-reaction--LIKE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Like" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7ze70iqo2l1rn7hwfoykiwjod"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> <div class="selected-reaction--PRAISE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Celebrate" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/czva5w81r4b0pjr7sh5r4nbw9"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Celebrate</span> </div> <div class="selected-reaction--APPRECIATION flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Support" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/8kvqqk9m1eu5ffqkdlum1ka1m"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Support</span> </div> <div class="selected-reaction--EMPATHY flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Love" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5yukss5d7kh4xrbd5642z6tk0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Love</span> </div> <div class="selected-reaction--INTEREST flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Insightful" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/es4dlamdpym2zbuhglwx2cuz0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Insightful</span> </div> <div class="selected-reaction--ENTERTAINMENT flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Funny" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0rqrq0h755yqqu59fy047ayt"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Funny</span> </div> </div> </template> <code id="i18n_reaction_singular" style="display: none"><!--"%numReactions% Reaction"--></code> <code id="i18n_reactions_plural" style="display: none"><!--"%numReactions% Reactions"--></code> <div class="flex items-center font-sans text-sm babybear:text-xs contribution-social-activity__social-actions before:middot flex items-center justify-start gap-1 pr-1 before:mx-0.5" data-sap-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265914844875268096)"> <div class="flex items-center font-normal text-color-text-low-emphasis no-underline visited:text-color-text-low-emphasis my-1" role="button" aria-label="2 Reactions" data-separate-ctas="false" data-test-id="social-actions__reactions" data-id="social-actions__reactions" data-num-reactions="2" data-singular="%numReactions%" data-plural="%numReactions%" data-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265914844875268096)" tabindex="0"> <img alt data-reaction-type="LIKE" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur" height="16px" width="16px"> <span aria-hidden="true" class="font-normal ml-0.5" data-test-id="social-actions__reaction-count"> 2 </span> </div> <code id="social-actions__reaction-image-APPRECIATION" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cib97epu77mrzque5gqlzjgaw"--></code> <!----><!----> <code id="social-actions__reaction-image-EMPATHY" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/37hg81qnm85dsy5mbqfifg9qs"--></code> <code id="social-actions__reaction-image-ENTERTAINMENT" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/e7ppwfmo0if15fgie4q5r4us4"--></code> <!----> <code id="social-actions__reaction-image-INTEREST" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4v7dh2d6cuqm24mzps1pqzeqt"--></code> <code id="social-actions__reaction-image-LIKE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur"--></code> <code id="social-actions__reaction-image-MAYBE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4iy169rwfs5rdhspekg2r5wc6"--></code> <code id="social-actions__reaction-image-PRAISE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cjrxeu0ese8oxe32kiom8kzoh"--></code> <!----><!----><!----><!----> </div> </div> <!----> </div> <!----><!----> </div> <!----><!----><!----> </li> <li class="contribution" data-contribution-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265685221814005761)" data-contributor-urn="urn:li:member:26521183" data-contribution-tracking-id="RHnzuUNdD8XlW1we7F8d0Q==" data-is-logged-in="false"> <div class="flex items-center justify-between"> <a href="https://in.linkedin.com/in/ninadkalamkar?trk=article-ssr-frontend-x-article" target="_blank" data-tracking-control-name="comment_actor" data-tracking-will-navigate class="contribution__lockup relative flex items-center overflow-hidden pr-1 font-sans hover:no-underline focus:no-underline xs:left-[-56px]"> <figure class="top-[4px] inline-flex lg:hidden"> <img class="inline-block relative rounded-[50%] w-4 h-4 " data-delayed-url="https://media.licdn.com/dms/image/v2/D4D03AQEEHJ8GMmvCNQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1689414208113?e=2147483647&v=beta&t=M_5c1F0JNKbmayqfvRoQ1BbRemihxgAuqhIHWu7KZcE" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <figure class="top-[4px] hidden lg:inline-flex"> <img class="inline-block relative rounded-[50%] w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/D4D03AQEEHJ8GMmvCNQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1689414208113?e=2147483647&v=beta&t=M_5c1F0JNKbmayqfvRoQ1BbRemihxgAuqhIHWu7KZcE" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Contributor profile photo"> </figure> <div class="min-w-0 ml-2"> <div class="flex items-center"> <span class="mr-0.5 truncate text-sm font-bold text-color-text lg:text-md"> Ninad Kalamkar </span> <!----><!----> </div> <p class="m-0 truncate text-sm text-color-text-low-emphasis md:text-md" data-test-id="contribution-lock-up-headline"> Experienced Program Manager | Solution Architect | Global Delivery | Data Analytics & Management </p> </div> </a> <div class="flex items-center"> <!----> <div class="ellipsis-menu absolute right-0 top-0 contribution-control-menu relative" data-feed-action="show-comment-dropdown" data-id="comment__ellipsis-menu" data-feed-control="control_menu" data-tracking-control-name="comment_control_menu" data-feed-action-type="expandControl" data-feed-action-category="expand"> <div class="collapsible-dropdown flex items-center relative hyphens-auto"> <button class="ellipsis-menu__trigger collapsible-dropdown__button btn-md btn-tertiary cursor-pointer !py-[6px] !px-1 flex items-center rounded-[50%] ellipsis-menu__trigger--small w-[32px] h-[32px] flex justify-center w-[40px] min-w-[40px]" aria-expanded="false" aria-label="Open menu" data-tracking-control-name="article-ssr-frontend-x-article_ellipsis-menu-trigger" tabindex="0"> <icon class="ellipsis-menu__trigger-icon m-0 p-0 centered-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/c26vw8uiog92lvrqov98hvbxr"></icon> </button> <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-auto top-[100%]" role="menu" tabindex="-1"> <!----> <li class="ellipsis-menu__item flex contribution-control-menu-item--copy" data-feed-action="copyComment" data-feed-control="comment_control_menu_copy" data-tracking-control-name="comment_control_menu_copy" data-feed-action-type="controlMenuCopy" data-feed-action-category="copy" data-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265685221814005761)" data-comment-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)"> <button class="contribution-control-menu-item ellipsis-menu__item-button flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " data-tracking-control-name="comment_control_menu_copy" data-feed-action-category="expand" data-feed-action-type="expandCopyContribution" role="menuitem"> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/85z203x9ymzz8gu3a3jmtxy81"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Copy link to contribution</span> </button> </li> <li class="ellipsis-menu__item flex" data-feed-action="semaphoreComment" data-feed-control="comment_control_menu_report" data-tracking-control-name="comment_control_menu_report" data-feed-action-type="expandContributionReporting" data-feed-action-category="expand" data-test-id="contribution-control-menu-report"> <a href="/uas/login?session_redirect=https%3A%2F%2Fwww.linkedin.com%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=comment-semaphore-sign-in-redirect&guestReportContentType=AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION&_f=guest-reporting" data-tracking-control-name="comment-semaphore-sign-in-redirect" data-tracking-will-navigate data-item-type="semaphore" data-semaphore-content-type="AUTO_GENERATED_SKILL_ARTICLE_CONTRIBUTION" data-semaphore-content-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265685221814005761)" data-semaphore-author-urn="urn:li:member:26521183" data-semaphore-tracking-prefix="comment-semaphore" data-is-logged-in="false" data-modal="semaphore__toggle" class="semaphore__toggle visited:text-color-text-secondary mx-0.25 flex items-center w-full py-1 px-2 cursor-pointer font-sans text-sm font-bold link-styled focus:link-styled link:no-underline active:bg-color-background-container-tint hover:bg-color-background-container-tint " role="menuitem"> <!----> <icon data-svg-class-name=" ellipsis-menu__item-icon text-color-icon h-[20px] w-[auto] mr-1 flex " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/eo60762wicg7snl6mo020acft"></icon> <span class=" ellipsis-menu__item-text inline-block text-color-text font-semibold ">Report contribution</span> </a> <!----> <template id="comment-reported-card-template"> <p class="comment-reported-card bg-color-background-container p-2 text-sm font-medium text-color-text-secondary"> Thanks for letting us know! You'll no longer see this contribution</p> </template> </li> <!----><!----> </ul> <!----> </div> </div> <code id="contributionCopyLink" style="display: none"><!--"Link copied to clipboard"--></code> <code id="contributionCopyFail" style="display: none"><!--"Copy failed, try again later."--></code> <code id="contributionCopyUnsupported" style="display: none"><!--"Copy to clipboard is unsupported."--></code> </div> </div> <div class="contribution__container left__border -mb-2 -mt-1 animate-show ml-0 pl-0 md:ml-[-41px] md:pl-[32px] pr-0 lg:ml-[-33px] lg:pl-[40px] lg:pr-1 pt-2 pb-4"> <div class="flex flex-col justify-between lg:flex-col"> <div class="flex items-center justify-between gap-1"> </div> </div> <div class="contribution__text-wrapper relative"> <p class="contribution__text mb-1 whitespace-pre-wrap pt-1 text-md leading-open text-color-text md:mb-0 md:pt-0 line-clamp-5 lg:text-lg" data-tracking-control-name="comment_text">Here's what worked for me: Optimize Data Models: Normalize/denormalize based on use case, use appropriate indexing, and partition large tables. Efficient Storage: Adopt formats like Parquet, apply compression, and use tiered storage for cost and performance. Tune Queries: Simplify SQL, use materialized views, and implement caching. Streamline Pipelines: Leverage ELT, parallel processing, and minimize data movement. Scale Smartly: Use horizontal scaling, auto-scaling, and workload isolation. Monitor & Govern: Leverage tools for monitoring, profiling, and anomaly detection; enforce data validation rules. Adopt Modern Tech: In-memory processing, data virtualization, and cloud-native tools like Azure Synapse.</p> <button class="contribution__see-more-button absolute bottom-0 right-0 hidden cursor-pointer border-0 bg-color-surface p-0 text-md leading-open text-color-text-secondary hover:text-color-action hover:underline lg:text-lg" data-tracking-control-name="comment_expand" data-feed-control="comment_expand" data-feed-action-type="expandContributionText" data-feed-action-category="EXPAND" role="button" type="button">…see more</button> </div> <!----> <div class="contribution__social-action-bar relative right-1 flex flex-row items-center justify-start gap-1"> <div class="contribution-social-activity inline-flex items-center justify-start"> <code id="i18n_reaction_selection_state" style="display: none"><!--"%reactionType% %selectionState%"--></code> <div class="reactions-menu flex flex-row relative items-center justify-center select-none [-webkit-user-select:none] pointer-events-auto contribution-social-activity__reactions-menu " data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265685221814005761)" data-reactions-count="1"> <a class="reactions-menu__link text-color-text contribution-social-activity__button flex items-center btn-sm btn-tertiary justify-center sm:flex-row sm:text-sm rounded-sm px-0.5 relative h-6 cursor-pointer w-full contribution-social-activity__reactions-menu " href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_contribution-social-activity_like-cta" target="_blank" data-tracking-control-name="article-ssr-frontend-x-article_contribution-social-activity_reactions-cta" data-parent-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265685221814005761)" data-tracking-will-navigate data-accessory-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265685221814005761)" data-reactions-count="1"> <!----> <div class="like-button-default flex flex-row items-center "> <icon class="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0" data-svg-class-name="contribution-social-activity__icon w-[24px] h-[24px] mr-0.5 sm:m-0--svg" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e2cf8dn8tvjcu9gl3qcxhw31q"> </icon> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> </a> </div> <template id="selected-reaction"> <div> <div class="selected-reaction--LIKE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Like" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7ze70iqo2l1rn7hwfoykiwjod"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Like</span> </div> <div class="selected-reaction--PRAISE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Celebrate" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/czva5w81r4b0pjr7sh5r4nbw9"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Celebrate</span> </div> <div class="selected-reaction--APPRECIATION flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Support" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/8kvqqk9m1eu5ffqkdlum1ka1m"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Support</span> </div> <div class="selected-reaction--EMPATHY flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Love" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5yukss5d7kh4xrbd5642z6tk0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Love</span> </div> <div class="selected-reaction--INTEREST flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Insightful" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/es4dlamdpym2zbuhglwx2cuz0"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Insightful</span> </div> <div class="selected-reaction--ENTERTAINMENT flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Funny" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0rqrq0h755yqqu59fy047ayt"> <span class="contribution-social-activity__button-text sm:pl-0.5 text-md font-bold hidden md:block">Funny</span> </div> </div> </template> <code id="i18n_reaction_singular" style="display: none"><!--"%numReactions% Reaction"--></code> <code id="i18n_reactions_plural" style="display: none"><!--"%numReactions% Reactions"--></code> <div class="flex items-center font-sans text-sm babybear:text-xs contribution-social-activity__social-actions before:middot flex items-center justify-start gap-1 pr-1 before:mx-0.5" data-sap-comment-urn="urn:li:comment:(articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265685221814005761)"> <div class="flex items-center font-normal text-color-text-low-emphasis no-underline visited:text-color-text-low-emphasis my-1" role="button" aria-label="1 Reaction" data-separate-ctas="false" data-test-id="social-actions__reactions" data-id="social-actions__reactions" data-num-reactions="1" data-singular="%numReactions%" data-plural="%numReactions%" data-entity-urn="urn:li:comment:(urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153),7265685221814005761)" tabindex="0"> <img alt data-reaction-type="EMPATHY" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/37hg81qnm85dsy5mbqfifg9qs" height="16px" width="16px"> <span aria-hidden="true" class="font-normal ml-0.5" data-test-id="social-actions__reaction-count"> 1 </span> </div> <code id="social-actions__reaction-image-APPRECIATION" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cib97epu77mrzque5gqlzjgaw"--></code> <!----><!----> <code id="social-actions__reaction-image-EMPATHY" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/37hg81qnm85dsy5mbqfifg9qs"--></code> <code id="social-actions__reaction-image-ENTERTAINMENT" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/e7ppwfmo0if15fgie4q5r4us4"--></code> <!----> <code id="social-actions__reaction-image-INTEREST" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4v7dh2d6cuqm24mzps1pqzeqt"--></code> <code id="social-actions__reaction-image-LIKE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur"--></code> <code id="social-actions__reaction-image-MAYBE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4iy169rwfs5rdhspekg2r5wc6"--></code> <code id="social-actions__reaction-image-PRAISE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cjrxeu0ese8oxe32kiom8kzoh"--></code> <!----><!----><!----><!----> </div> </div> <!----> </div> <!----><!----> </div> <!----><!----><!----> </li> </ul> <div class="qa-article-redesign article-segment__cta-container ml-[-18px] lg:ml-0"> <a class="btn-md btn-tertiary inline-block relative right-[14px] load-more__cta load-more__cta--guest" href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article" target="_self" data-tracking-control-name="article-ssr-frontend-x-article_more_comments" data-tracking-will-navigate data-test-link data-contributions-count="18" data-feed-control="article-ssr-frontend-x-article_more_comments" data-feed-action-category="EXPAND" data-feed-action-type="expandMoreContributions" data-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)" data-is-reply="false" data-test-load-more-contributions> <span> View more answers </span> <!----></a> <div class="loader load-more__loader m-2 grow " data-test-id="load-more-loader" data-thread-urn="urn:li:articleSegment:(urn:li:linkedInArticle:7263262585364332544,7263262586945585153)"> <div class="loader__container mb-2 overflow-hidden"> <icon class="loader__icon inline-block loader__icon--default text-color-progress-loading" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/ddi43qwelxeqjxdd45pe3fvs1" data-svg-class-name="loader__icon-svg--small fill-currentColor h-[30px] min-h-[30px] w-[30px] min-w-[30px]"></icon> </div> </div> <code id="loadMoreErrorText" style="display: none"><!--"Sorry, something went wrong while loading more contributions."--></code> <code id="loadMoreErrorButton" style="display: none"><!--"Try refreshing the page."--></code> </div> </div> <div class="block pt-[120px]"> <div class="md:pb-2 pb-1 md:hidden block" data-test-qa-redesign-publisher-author-card> <div class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link publisher-author-card mb-4"> <a class="base-card__full-link absolute top-0 right-0 bottom-0 left-0 p-0 z-[2]" href="https://www.linkedin.com/showcase/skills-data-architecture/" data-tracking-control-name="article-ssr-frontend-x-article_publisher-author-card" data-tracking-will-navigate> <span class="sr-only"> Data Architecture </span> </a> <img class="inline-block relative w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/C4E0BAQHsVLSfXGFBpg/company-logo_100_100/company-logo_100_100/0/1674595242351?e=2147483647&v=beta&t=Ba7ImZODSb_D45g0tQVpfbkuLDk7uzWrwHwexS427x8" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/cs8pjfgyw96g44ln9r7tct85f" alt="Data Architecture"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full "> <!----> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> Data Architecture </h3> <!----> <!----> <div class="body-text text-color-text-low-emphasis base-main-card__metadata"> <!----> </div> <!----> </div> <div class="base-main-card__ctas z-[3] self-center ml-3 babybear:ml-1 babybear:self-start"> <a class="base-main-card__cta btn-sm btn-secondary" href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_publisher-author-card" data-tracking-control-name="article-ssr-frontend-x-article_publisher-author-card" data-tracking-will-navigate> + Follow </a> </div> </div> </div> <div class="md:pb-2 pb-1 block" data-test-qa-redesign-survey> <!-- Entry --> <!-- Confirmation --> <div class="x-article-survey x-article-feedback-entry mb-2 rounded-md bg-color-surface py-2"> <div class="x-article-survey-entry"> <div class="md:flex items-center"> <div class="flex-grow pr-2"> <h2 class="pb-0.5 text-md font-bold text-color-text">Rate this article</h2> <div class="text-sm text-color-text-secondary">We created this article with the help of AI. What do you think of it?</div> </div> <div class="flex-shrink-0 pb-1 pt-1.5 md:pt-1 "> <a class="x-article-survey-cta-good btn-sm btn-secondary mr-1 " href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article" target="_self" data-tracking-control-name="article_quality_feedback_great" data-tracking-will-navigate data-test-link data-content-urn="urn:li:linkedInArticle:7263262585364332544" data-feed-action-category="SHARE_QUALITY_FEEDBACK" data-feed-action-type="feedback_article_is_great" data-feed-control="article_quality_feedback_great"> It’s great <!----></a> <a class="x-article-survey-cta-not-good btn-sm btn-secondary " href="https://www.linkedin.com/signup/cold-join?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article" target="_self" data-tracking-control-name="article_quality_feedback_not_great" data-tracking-will-navigate data-test-link data-content-urn="urn:li:linkedInArticle:7263262585364332544" data-feed-action-category="SHARE_QUALITY_FEEDBACK" data-feed-action-type="feedback_article_is_not_great" data-feed-control="article_quality_feedback_not_great" data-modal="x-article-feedback-outlet"> It’s not so great <!----></a> </div> </div> </div> <div class="x-article-survey-confirmation hidden"> <h2 class="pb-0.5 text-md font-bold text-color-text">Thanks for your feedback</h2> <div class="x-article-survey-confirmation-body text-sm text-color-text-secondary">Your feedback is private. Like or react to bring the conversation to your network.</div> </div> </div> <code id="embed_x_article_feedback_title_initial" style="display: none"><!--"Tell us more"--></code> <code id="embed_x_article_feedback_title_confirmation" style="display: none"><!--"Thanks for your feedback"--></code> <code id="embed_x_content_urn" style="display: none"><!--"urn:li:linkedInArticle:7263262585364332544"--></code> <div class="x-article-feedback-modal-wrapper"> <!----> <div class> <!----> <div id="x-article-feedback-modal" class="modal " data-outlet="x-article-feedback-outlet"> <!----> <div class="modal__overlay flex items-center bg-color-background-scrim justify-center fixed bottom-0 left-0 right-0 top-0 opacity-0 invisible pointer-events-none z-[1000] transition-[opacity] ease-[cubic-bezier(0.25,0.1,0.25,1.0)] duration-[0.17s] py-4 " aria-hidden="true"> <section aria-modal="true" role="dialog" aria-labelledby="x-article-feedback-modal-modal-header" tabindex="-1" class="max-h-full modal__wrapper overflow-auto p-0 bg-color-surface max-w-[1128px] min-h-[160px] relative scale-[0.25] shadow-sm shadow-color-border-faint transition-[transform] ease-[cubic-bezier(0.25,0.1,0.25,1.0)] duration-[0.33s] focus:outline-0 modal__wrapper--with-footer flex flex-col w-[1128px] mamabear:w-[744px] babybear:w-[360px] rounded-md"> <header class="modal__header flex items-center justify-between py-1.5 px-3 "> <h2 id="x-article-feedback-modal-modal-header" class="modal__title font-normal leading-open text-color-text text-lg">Tell us more</h2> <button class="modal__dismiss modal__dismiss--with-icon btn-tertiary h-[40px] w-[40px] p-0 rounded-full indent-0 " aria-label="Dismiss" data-tracking-control-name="article_quality_feedback_modal_dismiss" type="button"> <icon class="modal__dismiss-icon relative top-[2px]" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/gs508lg3t2o81tq7pmcgn6m2"></icon> </button> <!----> </header> <div class="modal__main w-full flex-1"> <div class="x-article-feedback__content mx-3 mb-2 text-color-text"></div> <template id="x-article-feedback-content-initial-template"> <div class="x-article-feedback__content p-3"> <div class="mb-2 text-color-text">Tell us why you didn’t like this article.</div> <ul class="x-article-feedback-modal-options mb-3"> <li class="py-1" data-x-article-feedback-item="action"> <label> <div class="flex"> <input class="scale-150" data-tracking-control-name="article_quality_feedback_select_option" name="x-article-feedback-action" value="feedback_not_professional_topic" data-x-article-feedback-input="feedback_not_professional_topic" type="radio"> <span class="ml-1 inline-block text-md text-color-text" data-attr="title">It’s not on a professional topic</span> </div> </label> </li> <li class="py-1" data-x-article-feedback-item="action"> <label> <div class="flex"> <input class="scale-150" data-tracking-control-name="article_quality_feedback_select_option" name="x-article-feedback-action" value="feedback_inaccuracies" data-x-article-feedback-input="feedback_inaccuracies" type="radio"> <span class="ml-1 inline-block text-md text-color-text" data-attr="title">It contains inaccuracies</span> </div> </label> </li> <li class="py-1" data-x-article-feedback-item="action"> <label> <div class="flex"> <input class="scale-150" data-tracking-control-name="article_quality_feedback_select_option" name="x-article-feedback-action" value="feedback_offensive_language" data-x-article-feedback-input="feedback_offensive_language" type="radio"> <span class="ml-1 inline-block text-md text-color-text" data-attr="title">It has offensive language</span> </div> </label> </li> <li class="py-1" data-x-article-feedback-item="action"> <label> <div class="flex"> <input class="scale-150" data-tracking-control-name="article_quality_feedback_select_option" name="x-article-feedback-action" value="feedback_harmful_advice" data-x-article-feedback-input="feedback_harmful_advice" type="radio"> <span class="ml-1 inline-block text-md text-color-text" data-attr="title">It has harmful advice</span> </div> </label> </li> <li class="py-1" data-x-article-feedback-item="action"> <label> <div class="flex"> <input class="scale-150" data-tracking-control-name="article_quality_feedback_select_option" name="x-article-feedback-action" value="feedback_stereotypes_or_bias" data-x-article-feedback-input="feedback_stereotypes_or_bias" type="radio"> <span class="ml-1 inline-block text-md text-color-text" data-attr="title">It contains stereotypes or bias</span> </div> </label> </li> <li class="py-1" data-x-article-feedback-item="action"> <label> <div class="flex"> <input class="scale-150" data-tracking-control-name="article_quality_feedback_select_option" name="x-article-feedback-action" value="feedback_redundant_or_unclear" data-x-article-feedback-input="feedback_redundant_or_unclear" type="radio"> <span class="ml-1 inline-block text-md text-color-text" data-attr="title">It’s redundant and unclear</span> </div> </label> </li> <li class="py-1" data-x-article-feedback-item="action"> <label> <div class="flex"> <input class="scale-150" data-tracking-control-name="article_quality_feedback_select_option" name="x-article-feedback-action" value="feedback_poorly_written" data-x-article-feedback-input="feedback_poorly_written_en" type="radio"> <span class="ml-1 inline-block text-md text-color-text" data-attr="title">Translation quality is poor</span> </div> </label> </li> <li class="py-1" data-x-article-feedback-item="action"> <label> <div class="flex"> <input class="scale-150" data-tracking-control-name="article_quality_feedback_select_option" name="x-article-feedback-action" value="feedback_not_relevant" data-x-article-feedback-input="feedback_not_relevant_en" type="radio"> <span class="ml-1 inline-block text-md text-color-text" data-attr="title">It’s not relevant in my country, region or culture</span> </div> </label> </li> </ul> <div class="rounded-md bg-color-surface-tint p-2 text-sm"> <div class="mb-1 text-color-text">If you think something in this article goes against our <a href="https://www.linkedin.com/legal/professional-community-policies" target="_blank" class="link-no-visited-state" data-feed-action-category="VIEW" data-feed-action-type="feedback_pcp_link" data-feed-control="article_quality_feedback_pcp_link" data-tracking-will-navigate="" data-x-article-feedback-action="policy" data-tracking-control-name="article_quality_feedback_pcp_link">Professional Community Policies</a>, please let us know.</div> <a href="/uas/login?trk=article_quality_feedback-sign-in-redirect&guestReportContentType=AUTO_GENERATED_SKILL_ARTICLE&_f=guest-reporting" data-tracking-control-name="article_quality_feedback_report_article" data-tracking-will-navigate data-item-type="semaphore" data-semaphore-content-type="AUTO_GENERATED_SKILL_ARTICLE" data-semaphore-content-urn="urn:li:linkedInArticle:7263262585364332544" data-semaphore-tracking-prefix="article_quality_feedback" data-is-logged-in="false" data-modal="semaphore__toggle" class="semaphore__toggle visited:text-color-text-secondary link-no-visited-state" data-content-urn="urn:li:linkedInArticle:7263262585364332544" data-x-article-feedback-action="report_article" data-feed-control="article_quality_feedback_report_article" data-feed-action-category="REPORT" data-feed-action-type="feedback_report_offramp"> <!----> <span>Report this article</span> </a> <!----> </div> </div> </template> <template id="x-article-feedback-content-confirmation-template"> <div class="x-article-feedback__content p-3"> <div class="mb-2 text-color-text">We appreciate you letting us know. Though we’re unable to respond directly, your feedback helps us improve this experience for everyone.</div> <div class="rounded-md bg-color-surface-tint p-2 text-sm"> <div class="x-article-feedback-modal-confirmation-body2 mb-1 text-color-text">If you think this goes against our <a href="https://www.linkedin.com/legal/professional-community-policies" target="_blank" class="link-no-visited-state" data-feed-action-category="VIEW" data-feed-action-type="feedback_confirmation_pcp_link" data-feed-control="article_quality_feedback_confirmation_pcp_link" data-tracking-will-navigate="" data-x-article-feedback-action="policy_confirmation" data-tracking-control-name="article_quality_feedback_confirmation_pcp_link">Professional Community Policies</a>, please let us know.</div> <a href="/uas/login?trk=article_quality_feedback-sign-in-redirect&guestReportContentType=AUTO_GENERATED_SKILL_ARTICLE&_f=guest-reporting" data-tracking-control-name="article_quality_feedback_confirmation_screen_report_article" data-tracking-will-navigate data-item-type="semaphore" data-semaphore-content-type="AUTO_GENERATED_SKILL_ARTICLE" data-semaphore-content-urn="urn:li:linkedInArticle:7263262585364332544" data-semaphore-tracking-prefix="article_quality_feedback" data-is-logged-in="false" data-modal="semaphore__toggle" class="semaphore__toggle visited:text-color-text-secondary link-no-visited-state" data-x-article-feedback-action="report_article_confirmation" data-feed-control="article_quality_feedback_confirmation_screen_report_article" data-feed-action-category="REPORT" data-feed-action-type="feedback_confirmation_report_offramp"> <!----> <span>Report this article</span> </a> <!----> </div> </div> </template> </div> <footer class="modal__footer flex justify-end py-1.5 px-3 border-t-1 border-solid border-color-border-faint"> <button class="btn-md btn-secondary" data-x-article-feedback-action="cancel" data-tracking-control-name="article_quality_feedback_cancel_option" data-feed-control="article_quality_feedback_cancel_option" data-feed-action-category="DISMISS" data-feed-action-type="feedback_cancel_option">Cancel</button> <button class="btn-md btn-primary ml-1" data-x-article-feedback-action="submit" data-tracking-control-name="article_quality_feedback_submit_option" data-feed-control="article_quality_feedback_submit_option" data-feed-action-category="SHARE_QUALITY_FEEDBACK" disabled="true">Submit</button> <button class="btn-md btn-primary ml-1 hidden" data-x-article-feedback-action="done" data-tracking-control-name="article_quality_feedback_done">Done</button> </footer> </section> </div> </div> </div> </div> <a href="/uas/login?session_redirect=https%3A%2F%2Fwww.linkedin.com%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article-sign-in-redirect&guestReportContentType=AUTO_GENERATED_SKILL_ARTICLE&_f=guest-reporting" data-tracking-control-name="article-ssr-frontend-x-article-sign-in-redirect" data-tracking-will-navigate data-item-type="semaphore" data-semaphore-content-type="AUTO_GENERATED_SKILL_ARTICLE" data-semaphore-content-urn="urn:li:linkedInArticle:7263262585364332544" data-semaphore-tracking-prefix="article-ssr-frontend-x-article" data-is-logged-in="false" data-modal="semaphore__toggle" class="semaphore__toggle visited:text-color-text-secondary mb-4 block pb-2 pr-2 text-md font-bold text-color-text visited:text-color-text-secondary text-left"> <!----> <span>Report this article</span> </a> <!----> </div> <div class="md:pb-6 pb-3" data-test-qa-redesign-more-articles-carousel> <!----> <section class="slide-list relative more-articles__slide-list px-0 md:w-[452px]"> <header class="slide-list__header mb-1.5"> <h2 class="slide-list__heading font-bold mb-0.5 text-color-text text-lg">More articles on Data Architecture</h2> <!----> </header> <div class="slide-list__nav"> <div class="slide-list__nav-wrap absolute flex h-full items-center top-0 z-1 slide-list__nav-wrap--prev left-[-20px]"> <div class="previous-slide-list__a11y-notification sr-only hidden" role="alert"> No more previous content </div> <button data-tracking-control-name="article-ssr-frontend-x-article_slide_list_prev_button" class="slide-list__nav-button btn-sm btn-overlay cursor-pointer disabled:hidden" aria-label="Previous Slide" data-direction="prev" disabled> <icon class="slide-list__nav-icon flex items-center justify-center pointer-events-none h-3 rtl:-scale-x-100 rtl:translate-x-[7px]" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e5ka7p8s9n5r0z9p6kpmm3hig"></icon> </button> </div> </div> <div class="relative overflow-hidden "> <ul class="slide-list__list items-stretch flex list-none transition-all duration-slow ease-standard "> <li class="slide-list__item mr-2 rtl:ml-2"> <a class="x-more-articles-card__link outline-offset-[-2px] hover:no-underline focus:no-underline active:no-underline" href="https://www.linkedin.com/advice/0/you-need-migrate-systems-without-compromising-6kpbf" aria-label="You need to migrate systems without compromising data security. How do you keep accessibility intact?" data-tracking-control-name="recommended_article_card" data-tracking-will-navigate="true"> <div class="x-more-articles-card container-lined flex h-[119px] w-[272px] overflow-hidden hover:container-raised active:container-raised"> <!----> <div class="x-more-articles-card__text p-1.5"> <p class="x-more-articles-card__title break-words text-sm font-bold text-color-text line-clamp-3"> You need to migrate systems without compromising data security. How do you keep accessibility intact? </p> <!----> </div> </div> </a> </li> <li class="slide-list__item mr-2 rtl:ml-2"> <a class="x-more-articles-card__link outline-offset-[-2px] hover:no-underline focus:no-underline active:no-underline" href="https://www.linkedin.com/advice/0/your-team-values-speed-over-data-standards-how-bexvf" aria-label="Your team values speed over data standards. How can you ensure quality while meeting deadlines?" data-tracking-control-name="recommended_article_card" data-tracking-will-navigate="true"> <div class="x-more-articles-card container-lined flex h-[119px] w-[272px] overflow-hidden hover:container-raised active:container-raised"> <!----> <div class="x-more-articles-card__text p-1.5"> <p class="x-more-articles-card__title break-words text-sm font-bold text-color-text line-clamp-3"> Your team values speed over data standards. How can you ensure quality while meeting deadlines? </p> <!----> </div> </div> </a> </li> <li class="slide-list__item mr-2 rtl:ml-2"> <a class="x-more-articles-card__link outline-offset-[-2px] hover:no-underline focus:no-underline active:no-underline" href="https://www.linkedin.com/advice/0/security-measures-tightening-data-access-how-iydlc" aria-label="Security measures are tightening data access. How do you keep stakeholders satisfied?" data-tracking-control-name="recommended_article_card" data-tracking-will-navigate="true"> <div class="x-more-articles-card container-lined flex h-[119px] w-[272px] overflow-hidden hover:container-raised active:container-raised"> <!----> <div class="x-more-articles-card__text p-1.5"> <p class="x-more-articles-card__title break-words text-sm font-bold text-color-text line-clamp-3"> Security measures are tightening data access. How do you keep stakeholders satisfied? </p> <!----> </div> </div> </a> </li> <li class="slide-list__item mr-2 rtl:ml-2"> <a class="x-more-articles-card__link outline-offset-[-2px] hover:no-underline focus:no-underline active:no-underline" href="https://www.linkedin.com/advice/0/youre-revamping-your-data-architecture-design-emo7f" aria-label="You're revamping your data architecture design. How can you cut costs while maintaining scalability?" data-tracking-control-name="recommended_article_card" data-tracking-will-navigate="true"> <div class="x-more-articles-card container-lined flex h-[119px] w-[272px] overflow-hidden hover:container-raised active:container-raised"> <!----> <div class="x-more-articles-card__text p-1.5"> <p class="x-more-articles-card__title break-words text-sm font-bold text-color-text line-clamp-3"> You're revamping your data architecture design. How can you cut costs while maintaining scalability? </p> <!----> </div> </div> </a> </li> <li class="slide-list__item mr-2 rtl:ml-2"> <a class="x-more-articles-card__link outline-offset-[-2px] hover:no-underline focus:no-underline active:no-underline" href="https://www.linkedin.com/advice/0/youre-tasked-migrating-legacy-system-how-do-you-xcfif" aria-label="You're tasked with migrating a legacy system. How do you secure sensitive data effectively?" data-tracking-control-name="recommended_article_card" data-tracking-will-navigate="true"> <div class="x-more-articles-card container-lined flex h-[119px] w-[272px] overflow-hidden hover:container-raised active:container-raised"> <!----> <div class="x-more-articles-card__text p-1.5"> <p class="x-more-articles-card__title break-words text-sm font-bold text-color-text line-clamp-3"> You're tasked with migrating a legacy system. How do you secure sensitive data effectively? </p> <!----> </div> </div> </a> </li> <li class="slide-list__item mr-2 rtl:ml-2"> <a class="x-more-articles-card__link outline-offset-[-2px] hover:no-underline focus:no-underline active:no-underline" href="https://www.linkedin.com/advice/0/youve-encountered-data-quality-issues-post-migration-ucptc" aria-label="You've encountered data quality issues post-migration. How can you ensure your data is reliable and accurate?" data-tracking-control-name="recommended_article_card" data-tracking-will-navigate="true"> <div class="x-more-articles-card container-lined flex h-[119px] w-[272px] overflow-hidden hover:container-raised active:container-raised"> <!----> <div class="x-more-articles-card__text p-1.5"> <p class="x-more-articles-card__title break-words text-sm font-bold text-color-text line-clamp-3"> You've encountered data quality issues post-migration. How can you ensure your data is reliable and accurate? </p> <!----> </div> </div> </a> </li> </ul> </div> <div class="slide-list__nav"> <div class="slide-list__nav-wrap absolute flex h-full items-center top-0 z-1 slide-list__nav-wrap--next right-[-20px]"> <div class="next-slide-list__a11y-notification sr-only hidden" role="alert"> No more next content </div> <button data-tracking-control-name="article-ssr-frontend-x-article_slide_list_next_button" class="slide-list__nav-button btn-sm btn-overlay cursor-pointer disabled:hidden" aria-label="Next Slide" data-direction="next"> <icon class="slide-list__nav-icon flex items-center justify-center pointer-events-none h-3 rtl:-scale-x-100 rtl:translate-x-[7px]" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/c9dcz2pyrbwi3sr6xwxigmvlz"></icon> </button> </div> </div> <div class="flex items-center mt-2"> <!----> <a aria-label="See all articles on Data Architecture" class="absolute flex gap-1 items-center link-styled right-0 text-sm slide_list__see-all" data-tracking-control-name="article-ssr-frontend-x-article_see_all" data-tracking-will-navigate href="https://www.linkedin.com/pulse/topics/engineering-s166/data-architecture-s18213/?trk=article-ssr-frontend-x-article"> <span>See all</span> <icon class="h-2 w-2" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/588y48bk4e72ybpxav0sjkozs"></icon> </a> </div> <code id="i18n_slide_list_current_slide_aria_label" style="display: none"><!--"Current Item"--></code> </section> </div> <!----> <div class="md:pb-6 pb-3" data-test-qa-redesign-related-skills> <section class="related-skills"> <h2 class="mb-1 ml-0 md:ml-1 mt-2 text-lg font-bold text-color-text"> Explore Other Skills </h2> <div class="show-more-less"> <!----> <ul data-max-num-to-show="6" class="show-more-less__list show-more-less__list--hide-after-6" data-impression-id="article-ssr-frontend-x-article-related-skills_show-more-less"> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/programming-s698/" data-tracking-control-name="article-ssr-frontend-x-article-Programming" data-tracking-will-navigate>Programming</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/web-development-s764/" data-tracking-control-name="article-ssr-frontend-x-article-Web Development" data-tracking-will-navigate>Web Development</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/machine-learning-s3289/" data-tracking-control-name="article-ssr-frontend-x-article-Machine Learning" data-tracking-will-navigate>Machine Learning</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/software-development-s602/" data-tracking-control-name="article-ssr-frontend-x-article-Software Development" data-tracking-will-navigate>Software Development</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/computer-science-s1541/" data-tracking-control-name="article-ssr-frontend-x-article-Computer Science" data-tracking-will-navigate>Computer Science</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/data-engineering-s50513/" data-tracking-control-name="article-ssr-frontend-x-article-Data Engineering" data-tracking-will-navigate>Data Engineering</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/data-analytics-s33049/" data-tracking-control-name="article-ssr-frontend-x-article-Data Analytics" data-tracking-will-navigate>Data Analytics</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/data-science-s50061/" data-tracking-control-name="article-ssr-frontend-x-article-Data Science" data-tracking-will-navigate>Data Science</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/artificial-intelligence-(ai)-s2407/" data-tracking-control-name="article-ssr-frontend-x-article-Artificial Intelligence (AI)" data-tracking-will-navigate>Artificial Intelligence (AI)</a> </li> <li class="inline-flex"> <a class="btn-sm btn-secondary mx-0.5 mt-1 mb-0.5 w-fit hover:no-underline papabear:btn-md" href="https://www.linkedin.com/pulse/topics/engineering-s166/cloud-computing-s2801/" data-tracking-control-name="article-ssr-frontend-x-article-Cloud Computing" data-tracking-will-navigate>Cloud Computing</a> </li> </ul> <button class="related-skills-show-more show-more-less__more-button btn-sm btn-secondary mx-0.5 my-1 papabear:btn-md" data-tracking-control-name="article-ssr-frontend-x-article_show_more" aria-label="Show more skills"> Show more <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/1iz8yi5qqd32dtilqm30ioj2o"></icon> </button> <button class="related-skills-show-more show-more-less__less-button show-more-less__button--hide btn-sm btn-secondary mx-0.5 my-1 papabear:btn-md" data-tracking-control-name="article-ssr-frontend-x-article_show_less" aria-label="Show less skills"> Show less <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5vxzfej9n3xp7g15m9qgckk0v"></icon> </button> </div> </section> </div> </div> </div> </div> </div> </div> </div> </section> <div class="modal-delete-confirmation-container"> <!----> <div id="modal-delete-confirmation" class="modal " data-outlet="default-outlet"> <!----> <div class="modal__overlay flex items-center bg-color-background-scrim justify-center fixed bottom-0 left-0 right-0 top-0 opacity-0 invisible pointer-events-none z-[1000] transition-[opacity] ease-[cubic-bezier(0.25,0.1,0.25,1.0)] duration-[0.17s] py-4 " aria-hidden="true"> <section aria-modal="true" role="dialog" aria-labelledby="modal-delete-confirmation-modal-header" tabindex="-1" class="max-h-full modal__wrapper overflow-auto p-0 bg-color-surface max-w-[1128px] min-h-[160px] relative scale-[0.25] shadow-sm shadow-color-border-faint transition-[transform] ease-[cubic-bezier(0.25,0.1,0.25,1.0)] duration-[0.33s] focus:outline-0 modal__wrapper--with-footer flex flex-col w-[774px] babybear:w-[360px] delete- rounded-md"> <div class="modal-header mx-3 flex justify-between py-3"> <h2 class="label py-1 text-lg font-medium leading-regular text-color-text" id="delete-modal-heading-label">Are you sure you want to delete your contribution?</h2> <h2 class="label py-1 text-lg font-medium leading-regular text-color-text hidden" id="delete-modal-reply-heading-label">Are you sure you want to delete your reply?</h2> <button class="modal__dismiss btn-tertiary h-[40px] w-[40px] p-0 rounded-full indent-0 delete-modal-dismiss-btn" aria-label="Close delete modal" data-tracking-control-name="delete_modal_dismiss"> <icon class="delete-modal__dismiss-icon h-3 w-3" data-svg-class-name="h-3 w-3" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/adzjokfylbe8pvjr9h8iv96mw"></icon> </button> </div> <div class="modal__main w-full flex-1"> <div class="delete-modal-content-container m-3 rounded-md bg-color-surface-accent-tint-1 dark:bg-color-surface-accent-tint-1"> <div class="delete-modal-content break-words p-3 font-normal text-color-text md:text-md lg:text-lg"></div> <div class="delete-contribution-author flex items-center overflow-hidden px-3 pb-3"></div> </div> </div> <footer class="modal__footer flex justify-end py-1.5 px-3 border-t-1 border-solid border-color-border-faint"> <div class="delete-modal-cta" id="delete-modal-cta"> <button data-tracking-control-name="comment_cancel_delete" data-action-type="cancel" class="delete-contribution-cta cancel-cta-btn btn-md text-color-text border desktop btn-secondary mr-1 border-solid border-black-a90">Cancel</button> <button data-tracking-control-name="comment_submit_delete" data-action-type="delete" data-feed-control="comment_submit_delete" data-feed-action-category="delete" data-feed-action-type="deleteContribution" class="delete-contribution-cta delete-cta-btn ease-linear duration-300 btn-md transition-all btn-primary"> <div class="loader delete-cta-loader inline"> <div class="loader__container mb-2 overflow-hidden"> <icon class="loader__icon inline-block loader__icon--default text-color-progress-loading" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/ddi43qwelxeqjxdd45pe3fvs1" data-svg-class-name="loader__icon-svg--x-small fill-currentColor h-[20px] min-h-[20px] w-[20px] min-w-[20px]"></icon> </div> </div> <span class="delete-cta-text">Delete</span> </button> </div> </footer> </section> </div> </div> </div> <code id="contributionDeleteError" style="display: none"><!--"Sorry, something went wrong while deleting your contribution."--></code> <code id="contributionDeleteSuccess" style="display: none"><!--"Successfully deleted your contribution."--></code> <code id="contributionReplyDeleteError" style="display: none"><!--"Sorry, something went wrong while deleting your reply."--></code> <code id="contributionReplyDeleteSuccess" style="display: none"><!--"Successfully deleted your reply."--></code> <code id="contributionDeletePageRefresh" style="display: none"><!--"Try refreshing the page."--></code> <code id="isMobile" style="display: none"><!--false--></code> <!----><!----><!----> </article> </div> <!----> </main> <!----> </div> <!----> <footer class="li-footer bg-transparent w-full "> <ul class="li-footer__list flex flex-wrap flex-row items-start justify-start w-full h-auto min-h-[50px] my-[0px] mx-auto py-3 px-2 papabear:w-[1128px] papabear:p-0"> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <span class="sr-only">LinkedIn</span> <icon class="li-footer__copy-logo text-color-logo-brand-alt inline-block self-center h-[14px] w-[56px] mr-1" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e12h2cd8ac580qen9qdd0qks8"></icon> <span class="li-footer__copy-text flex items-center">© 2024</span> </li> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://about.linkedin.com?trk=article-ssr-frontend-x-article_footer-about" data-tracking-control-name="article-ssr-frontend-x-article_footer-about" data-tracking-will-navigate> About </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/accessibility?trk=article-ssr-frontend-x-article_footer-accessibility" data-tracking-control-name="article-ssr-frontend-x-article_footer-accessibility" data-tracking-will-navigate> Accessibility </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/user-agreement?trk=article-ssr-frontend-x-article_footer-user-agreement" data-tracking-control-name="article-ssr-frontend-x-article_footer-user-agreement" data-tracking-will-navigate> User Agreement </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/privacy-policy?trk=article-ssr-frontend-x-article_footer-privacy-policy" data-tracking-control-name="article-ssr-frontend-x-article_footer-privacy-policy" data-tracking-will-navigate> Privacy Policy </a> </li> <!----> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/cookie-policy?trk=article-ssr-frontend-x-article_footer-cookie-policy" data-tracking-control-name="article-ssr-frontend-x-article_footer-cookie-policy" data-tracking-will-navigate> Cookie Policy </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/copyright-policy?trk=article-ssr-frontend-x-article_footer-copyright-policy" data-tracking-control-name="article-ssr-frontend-x-article_footer-copyright-policy" data-tracking-will-navigate> Copyright Policy </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://brand.linkedin.com/policies?trk=article-ssr-frontend-x-article_footer-brand-policy" data-tracking-control-name="article-ssr-frontend-x-article_footer-brand-policy" data-tracking-will-navigate> Brand Policy </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/psettings/guest-controls?trk=article-ssr-frontend-x-article_footer-guest-controls" data-tracking-control-name="article-ssr-frontend-x-article_footer-guest-controls" data-tracking-will-navigate> Guest Controls </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-solid-secondary hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/professional-community-policies?trk=article-ssr-frontend-x-article_footer-community-guide" data-tracking-control-name="article-ssr-frontend-x-article_footer-community-guide" data-tracking-will-navigate> Community Guidelines </a> </li> <!----> <li class="li-footer__item font-sans text-xs text-color-text-solid-secondary flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <div class="collapsible-dropdown collapsible-dropdown--footer collapsible-dropdown--up flex items-center relative hyphens-auto language-selector z-2"> <!----> <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-[100%] top-auto" role="menu" tabindex="-1"> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="العربية (Arabic)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ar_AE" data-locale="ar_AE" role="menuitem" lang="ar_AE"> العربية (Arabic) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="বাংলা (Bangla)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-bn_IN" data-locale="bn_IN" role="menuitem" lang="bn_IN"> বাংলা (Bangla) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Čeština (Czech)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-cs_CZ" data-locale="cs_CZ" role="menuitem" lang="cs_CZ"> Čeština (Czech) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Dansk (Danish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-da_DK" data-locale="da_DK" role="menuitem" lang="da_DK"> Dansk (Danish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Deutsch (German)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-de_DE" data-locale="de_DE" role="menuitem" lang="de_DE"> Deutsch (German) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Ελληνικά (Greek)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-el_GR" data-locale="el_GR" role="menuitem" lang="el_GR"> Ελληνικά (Greek) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="English (English) selected" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link--selected" data-tracking-control-name="language-selector-en_US" data-locale="en_US" role="menuitem" lang="en_US"> <strong>English (English)</strong> </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Español (Spanish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-es_ES" data-locale="es_ES" role="menuitem" lang="es_ES"> Español (Spanish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="فارسی (Persian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-fa_IR" data-locale="fa_IR" role="menuitem" lang="fa_IR"> فارسی (Persian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Suomi (Finnish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-fi_FI" data-locale="fi_FI" role="menuitem" lang="fi_FI"> Suomi (Finnish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Français (French)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-fr_FR" data-locale="fr_FR" role="menuitem" lang="fr_FR"> Français (French) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="हिंदी (Hindi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-hi_IN" data-locale="hi_IN" role="menuitem" lang="hi_IN"> हिंदी (Hindi) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Magyar (Hungarian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-hu_HU" data-locale="hu_HU" role="menuitem" lang="hu_HU"> Magyar (Hungarian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Bahasa Indonesia (Indonesian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-in_ID" data-locale="in_ID" role="menuitem" lang="in_ID"> Bahasa Indonesia (Indonesian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Italiano (Italian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-it_IT" data-locale="it_IT" role="menuitem" lang="it_IT"> Italiano (Italian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="עברית (Hebrew)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-iw_IL" data-locale="iw_IL" role="menuitem" lang="iw_IL"> עברית (Hebrew) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="日本語 (Japanese)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ja_JP" data-locale="ja_JP" role="menuitem" lang="ja_JP"> 日本語 (Japanese) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="한국어 (Korean)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ko_KR" data-locale="ko_KR" role="menuitem" lang="ko_KR"> 한국어 (Korean) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="मराठी (Marathi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-mr_IN" data-locale="mr_IN" role="menuitem" lang="mr_IN"> मराठी (Marathi) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Bahasa Malaysia (Malay)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ms_MY" data-locale="ms_MY" role="menuitem" lang="ms_MY"> Bahasa Malaysia (Malay) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Nederlands (Dutch)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-nl_NL" data-locale="nl_NL" role="menuitem" lang="nl_NL"> Nederlands (Dutch) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Norsk (Norwegian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-no_NO" data-locale="no_NO" role="menuitem" lang="no_NO"> Norsk (Norwegian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="ਪੰਜਾਬੀ (Punjabi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pa_IN" data-locale="pa_IN" role="menuitem" lang="pa_IN"> ਪੰਜਾਬੀ (Punjabi) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Polski (Polish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pl_PL" data-locale="pl_PL" role="menuitem" lang="pl_PL"> Polski (Polish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Português (Portuguese)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pt_BR" data-locale="pt_BR" role="menuitem" lang="pt_BR"> Português (Portuguese) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Română (Romanian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ro_RO" data-locale="ro_RO" role="menuitem" lang="ro_RO"> Română (Romanian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Русский (Russian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ru_RU" data-locale="ru_RU" role="menuitem" lang="ru_RU"> Русский (Russian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Svenska (Swedish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-sv_SE" data-locale="sv_SE" role="menuitem" lang="sv_SE"> Svenska (Swedish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="తెలుగు (Telugu)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-te_IN" data-locale="te_IN" role="menuitem" lang="te_IN"> తెలుగు (Telugu) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="ภาษาไทย (Thai)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-th_TH" data-locale="th_TH" role="menuitem" lang="th_TH"> ภาษาไทย (Thai) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Tagalog (Tagalog)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-tl_PH" data-locale="tl_PH" role="menuitem" lang="tl_PH"> Tagalog (Tagalog) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Türkçe (Turkish)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-tr_TR" data-locale="tr_TR" role="menuitem" lang="tr_TR"> Türkçe (Turkish) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Українська (Ukrainian)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-uk_UA" data-locale="uk_UA" role="menuitem" lang="uk_UA"> Українська (Ukrainian) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="Tiếng Việt (Vietnamese)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-vi_VN" data-locale="vi_VN" role="menuitem" lang="vi_VN"> Tiếng Việt (Vietnamese) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="简体中文 (Chinese (Simplified))" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-zh_CN" data-locale="zh_CN" role="menuitem" lang="zh_CN"> 简体中文 (Chinese (Simplified)) </button> </li> <li class="language-selector__item" role="presentation"> <!-- Adding aria-label to both the li and the button because screen reader focus goes to button on desktop and li on mobile--> <button aria-label="正體中文 (Chinese (Traditional))" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-zh_TW" data-locale="zh_TW" role="menuitem" lang="zh_TW"> 正體中文 (Chinese (Traditional)) </button> </li> <!----> </ul> <button class="language-selector__button select-none relative pr-2 font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover hover:cursor-pointer focus:text-color-link-focus focus:outline-dotted focus:outline-1" aria-expanded="false" data-tracking-control-name="footer-lang-dropdown_trigger"> <span class="language-selector__label-text mr-0.5 break-words"> Language </span> <icon class="language-selector__label-chevron w-2 h-2 absolute top-0 right-0" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> </div> </li> </ul> <!----> </footer> </div> <code id="ugcPostUrl" style="display: none"><!--"https://www.linkedin.com/feed/update/urn:li:ugcPost:7263262585720840193"--></code> <code id="ugcPost" style="display: none"><!--"urn:li:ugcPost:7263262585720840193"--></code> <code id="disableLinkedinShareRedirectLink" style="display: none"><!--true--></code> <code id="ugcPostUrn" style="display: none"><!--"urn:li:ugcPost:7263262585720840193"--></code> <code id="signInUrl" style="display: none"><!--"https://www.linkedin.com/uas/login?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc"--></code> <!----> <div class="article-social-activity z-[201] x-social-activity-wrapper xs:sticky bottom-0 flex justify-center border-t-1 border-solid border-color-border-faint bg-color-background-container " data-impression-id="article-ssr-frontend-x-article_x-social-details"> <!----> <div class="x-social-activity social-details x-social-activity-left flex flex-wrap w-full max-w-x-article-width-small justify-between lg:max-w-x-article-width"> <div class="flex x-social-activity-left flex-wrap"> <code id="i18n_reaction_selection_state" style="display: none"><!--"%reactionType% %selectionState%"--></code> <div class="reactions-menu flex flex-row relative items-center justify-center select-none [-webkit-user-select:none] pointer-events-auto" data-feed-control="article-ssr-frontend-x-article_x-social-details_like-toggle_reactions-cta"> <a class="reactions-menu__link text-color-text social-action-bar__button relative h-6 cursor-pointer w-full" href="https://www.linkedin.com/uas/login?session_redirect=%2Fadvice%2F1%2Fstruggling-data-architecture-performance-issues-hh8nc&trk=article-ssr-frontend-x-article_x-social-details_like-toggle_like-cta" target="_blank" data-tracking-control-name="article-ssr-frontend-x-article_x-social-details_like-toggle_reactions-cta" data-parent-urn="urn:li:ugcPost:7263262585720840193" data-tracking-will-navigate data-feed-control="article-ssr-frontend-x-article_x-social-details_like-toggle_reactions-cta"> <!----> <div class="like-button-default flex flex-row items-center "> <icon class="social-action-bar__icon" data-svg-class-name="social-action-bar__icon--svg" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e2cf8dn8tvjcu9gl3qcxhw31q"> </icon> <span class="social-action-bar__button-text">Like</span> </div> </a> </div> <template id="selected-reaction"> <div> <div class="selected-reaction--LIKE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Like" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7ze70iqo2l1rn7hwfoykiwjod"> <span class="social-action-bar__button-text">Like</span> </div> <div class="selected-reaction--PRAISE flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Celebrate" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/czva5w81r4b0pjr7sh5r4nbw9"> <span class="social-action-bar__button-text">Celebrate</span> </div> <div class="selected-reaction--APPRECIATION flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Support" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/8kvqqk9m1eu5ffqkdlum1ka1m"> <span class="social-action-bar__button-text">Support</span> </div> <div class="selected-reaction--EMPATHY flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Love" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5yukss5d7kh4xrbd5642z6tk0"> <span class="social-action-bar__button-text">Love</span> </div> <div class="selected-reaction--INTEREST flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Insightful" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/es4dlamdpym2zbuhglwx2cuz0"> <span class="social-action-bar__button-text">Insightful</span> </div> <div class="selected-reaction--ENTERTAINMENT flex flex-row items-center"> <img class="inline-block align-middle relative w-3 h-3 mr-1 babybear:mr-0 mb-0.5" alt="Funny" aria-hidden="true" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0rqrq0h755yqqu59fy047ayt"> <span class="social-action-bar__button-text">Funny</span> </div> </div> </template> <!----> <code id="i18n_copy_cta_message_success" style="display: none"><!--"Link copied to clipboard."--></code> <code id="i18n_copy_cta_message_error" style="display: none"><!--"Something went wrong while copying to clipboard."--></code> <div class="collapsible-dropdown flex items-center relative hyphens-auto social-share inline-block relative select-none x-social-share " data-share-message="Share" data-share-url="https://www.linkedin.com/advice/1/struggling-data-architecture-performance-issues-hh8nc?utm_source=share&utm_medium=guest_desktop" data-feed-control="article-ssr-frontend-x-article_x-social-details_social-share-intent_social-share_main_button" data-feed-action-category="EXPAND" data-feed-action-type="openShareMenu"> <!----> <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-[100%] top-auto" role="menu" tabindex="-1"> <li> <button data-tracking-control-name="article-ssr-frontend-x-article_x-social-details_social-share-intent_social-share_copy" class="social-share__item social-share-item" data-share-service="copy"> <icon class="social-share__item-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/aup4g97pdky3ff73gv9lyhjvx"></icon> <span class="social-share__item-text pl-1">Copy</span> </button> </li> <li> <button data-tracking-control-name="article-ssr-frontend-x-article_x-social-details_social-share-intent_social-share_linkedin" class="social-share__item social-share-item" data-share-service="linkedin"> <icon class="social-share__item-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/2uoxvguhsfspfnmr6tvfuyw4y" data-svg-class-name="text-color-text"></icon> <span class="social-share__item-text pl-1">LinkedIn</span> </button> </li> <li> <button data-tracking-control-name="article-ssr-frontend-x-article_x-social-details_social-share-intent_social-share_facebook" class="social-share__item social-share-item" data-share-service="facebook"> <icon class="social-share__item-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5xkjpykqkamtr6skk0vodqwd2"></icon> <span class="social-share__item-text pl-1">Facebook</span> </button> </li> <li> <button data-tracking-control-name="article-ssr-frontend-x-article_x-social-details_social-share-intent_social-share_twitter" class="social-share__item social-share-item" data-share-service="twitter"> <icon class="social-share__item-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4bmfmbwr1b97362o29qmjo1zj"></icon> <span class="social-share__item-text pl-1">Twitter</span> </button> </li> <!----> </ul> <button aria-expanded="false" class="social-share__button social-share__button-square social-share-button social-action-bar__button social-share-button--square " aria-label data-tracking-control-name="article-ssr-frontend-x-article_x-social-details_social-share-intent_social-share_main_button"> <icon class="social-share__button-icon " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/852gyy4s01pfis5qf9k99s6d2" data-svg-class-name="social-share-button-icon social-action-bar__icon--svg "></icon> <span class="social-share__button-text-square social-action-bar__button-text "> Share </span> </button> </div> </div> <code id="i18n_reaction_singular" style="display: none"><!--"%numReactions% Reaction"--></code> <code id="i18n_reactions_plural" style="display: none"><!--"%numReactions% Reactions"--></code> <div class="flex items-center font-sans text-sm babybear:text-xs" data-sap-comment-urn="urn:li:ugcPost:7263262585720840193"> <div class="flex items-center font-normal text-color-text-low-emphasis no-underline visited:text-color-text-low-emphasis my-1" role="button" aria-label="2 Reactions" data-test-id="social-actions__reactions" data-id="social-actions__reactions" data-num-reactions="2" data-singular="%numReactions%" data-plural="%numReactions%" data-entity-urn="urn:li:ugcPost:7263262585720840193" tabindex="0"> <img alt data-reaction-type="LIKE" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur" height="16px" width="16px"> <span aria-hidden="true" class="font-normal ml-0.5" data-test-id="social-actions__reaction-count"> 2 </span> </div> <code id="social-actions__reaction-image-APPRECIATION" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cib97epu77mrzque5gqlzjgaw"--></code> <!----><!----> <code id="social-actions__reaction-image-EMPATHY" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/37hg81qnm85dsy5mbqfifg9qs"--></code> <code id="social-actions__reaction-image-ENTERTAINMENT" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/e7ppwfmo0if15fgie4q5r4us4"--></code> <!----> <code id="social-actions__reaction-image-INTEREST" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4v7dh2d6cuqm24mzps1pqzeqt"--></code> <code id="social-actions__reaction-image-LIKE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/9sun4diznbhgyelaeryxy75ur"--></code> <code id="social-actions__reaction-image-MAYBE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/4iy169rwfs5rdhspekg2r5wc6"--></code> <code id="social-actions__reaction-image-PRAISE" style="display: none"><!--"https://static.licdn.com/aero-v1/sc/h/cjrxeu0ese8oxe32kiom8kzoh"--></code> <!----><!----> <div class="flex items-center font-normal text-color-text-low-emphasis no-underline visited:text-color-text-low-emphasis before:middot my-1" data-test-id="social-actions__comments" data-id="social-actions__comments" data-num-comments="18" data-singular="%numComments% Contribution" data-plural="%numComments% Contributions" data-entity-urn="urn:li:ugcPost:7263262585720840193"> 18 Contributions </div> <!----> </div> </div> </div> <!----><!----> <code id="contentUrn" style="display: none"><!--"urn:li:linkedInArticle:7263262585364332544"--></code> <div id="toasts" class="toasts fixed z-8 babybear:right-4 mamabear:right-4 papabear:min-h-[96px] invisible top:auto bottom-4 left-4 papabear:w-[400px] toasts--bottom" type="bottom"> <template id="toast-template"> <div class="toast container-raised flex toast--bottom transition ease-accelerate duration-xxslow " data-id="toast"> <div class="toast__message flex flex-1 babybear:items-center mamabear:items-center papabear:items-start py-2 px-1.5" data-id="toast__message" role="alert" tabindex="-1"> <div class="toast__message-content-container" data-id="toast__message-content-container"> <p class="toast__message-content font-sans text-sm opacity-90 inline babybear:self-center mamabear:self-center papabear:self-start" data-id="toast__message-content"></p> </div> </div> <button class="toast__dismiss-btn cursor-pointer babybear:self-center mamabear:self-center papabear:self-start pt-3 pb-2 papabear:py-2 pl-0.5 pr-0" data-id="toast__dismiss-btn" aria-label="Close"> <svg width="24" height="24" class="fill-color-icon"><path d="M13 4.32 9.31 8 13 11.69 11.69 13 8 9.31 4.31 13 3 11.69 6.69 8 3 4.31 4.31 3 8 6.69 11.68 3Z"></path></svg> </button> </div> </template> <template id="toast-icon-caution"> <icon class="text-color-icon-caution toast__icon w-3 h-3 shrink-0 mr-2" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/u6kgm8vi5s4rhtbgmjlphlp6"></icon> </template> <template id="toast-icon-error"> <icon class="text-color-icon-negative toast__icon w-3 h-3 shrink-0 mr-2" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/2ffvlzyh9wb65459t9va8w2ph"></icon> </template> <template id="toast-icon-gdpr"> <icon class="text-color-icon-neutral toast__icon w-3 h-3 shrink-0 mr-2" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/a0d85elrpgg38lskvq1kvzb3"></icon> </template> <template id="toast-icon-notify"> <icon class="text-color-icon-neutral toast__icon w-3 h-3 shrink-0 mr-2" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/de23f5me7dfm17unsj9up4vga"></icon> </template> <template id="toast-icon-success"> <icon class="text-color-icon-positive toast__icon w-3 h-3 shrink-0 mr-2" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/c44ryoszao52cyd0y87z7s0uf"></icon> </template> <template id="toast-cta"> <a class="toast__cta cta-link font-medium ml-0.5 text-sm text-inherit inline" target="_blank"></a> </template> </div> </div> <script src="https://static.licdn.com/aero-v1/sc/h/7itt46rafycxiwozfd111d2we" async></script> <!----> <script src="https://static.licdn.com/aero-v1/sc/h/e5k064ysjg279mcbgh94y7m73" async defer></script> <!----> </body> </html>