{"id":15237,"date":"2022-10-10T21:29:06","date_gmt":"2022-10-10T15:59:06","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/"},"modified":"2022-10-10T21:29:06","modified_gmt":"2022-10-10T15:59:06","slug":"solved-make-application-with-database-mysql-is-faster-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/","title":{"rendered":"[Solved] make application with database MySQL is faster [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

For db<\/p>\n

    \n
  1. Add indexes for frequently searched fields<\/li>\n
  2. Think about table partitioning, rarely searched data should be stored in archive tables<\/li>\n<\/ol>\n

    For backend<\/p>\n

      \n
    1. Optimize queries<\/li>\n
    2. Minimize cursor fetching<\/li>\n<\/ol>\n

      For client<\/p>\n

        \n
      1. Use pagination to avoid large data loading<\/li>\n
      2. Use async loading (SwingWorker for swing, Service for javafx) to avoid UI hanging<\/li>\n
      3. Don’t mix archive and working data in one UI form<\/li>\n<\/ol>\n<\/div>\n
        <\/div>\n<\/div>\n

        0<\/span> <\/p><\/div>\n<\/div>\n

        [ad_2]<\/p>\n

        solved make application with database MySQL is faster [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"

        [ad_1] For db Add indexes for frequently searched fields Think about table partitioning, rarely searched data should be stored in archive tables For backend Optimize queries Minimize cursor fetching For client Use pagination to avoid large data loading Use async loading (SwingWorker for swing, Service for javafx) to avoid UI hanging Don’t mix archive and … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[323,340,325,621],"class_list":["post-15237","post","type-post","status-publish","format-standard","hentry","category-solved","tag-java","tag-mysql","tag-performance","tag-swing"],"yoast_head":"\n[Solved] make application with database MySQL is faster [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] make application with database MySQL is faster [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] For db Add indexes for frequently searched fields Think about table partitioning, rarely searched data should be stored in archive tables For backend Optimize queries Minimize cursor fetching For client Use pagination to avoid large data loading Use async loading (SwingWorker for swing, Service for javafx) to avoid UI hanging Don’t mix archive and ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-10T15:59:06+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] make application with database MySQL is faster [closed]\",\"datePublished\":\"2022-10-10T15:59:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/\"},\"wordCount\":81,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"java\",\"mysql\",\"performance\",\"swing\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/\",\"name\":\"[Solved] make application with database MySQL is faster [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-10T15:59:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] make application with database MySQL is faster [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] make application with database MySQL is faster [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] make application with database MySQL is faster [closed] - JassWeb","og_description":"[ad_1] For db Add indexes for frequently searched fields Think about table partitioning, rarely searched data should be stored in archive tables For backend Optimize queries Minimize cursor fetching For client Use pagination to avoid large data loading Use async loading (SwingWorker for swing, Service for javafx) to avoid UI hanging Don’t mix archive and ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/","og_site_name":"JassWeb","article_published_time":"2022-10-10T15:59:06+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] make application with database MySQL is faster [closed]","datePublished":"2022-10-10T15:59:06+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/"},"wordCount":81,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["java","mysql","performance","swing"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/","name":"[Solved] make application with database MySQL is faster [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-10T15:59:06+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-make-application-with-database-mysql-is-faster-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] make application with database MySQL is faster [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=15237"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15237\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=15237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=15237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=15237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}