{"id":2211,"date":"2019-03-25T17:38:33","date_gmt":"2019-03-25T20:38:33","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb27358-databases-vs-tables-vs-fields\/"},"modified":"2023-03-07T17:10:51","modified_gmt":"2023-03-07T20:10:51","slug":"kb27358-databases-vs-tables-vs-fields","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb27358-databases-vs-tables-vs-fields\/","title":{"rendered":"KB-27358: Databases vs. Tables vs. Fields."},"content":{"rendered":"
\n

Question:<\/span><\/p>\n

In an application, I need to record the values of 25 variables in an Access database to be loaded by an E3Chart. Which of the options below is the best to do so?<\/p>\n

    \n
  1. Using one single database with one single Historic table with 25 fields.<\/li>\n
  2. Using one single database with 25 Historics tables with one single field in each table.<\/li>\n
  3. Using 25 databases, each one with a single Historic table with one single field.<\/li>\n<\/ol>\n

    Solution:<\/span>

    \nIn this case, the best choices are options 1 or 2, but you must also set up the periodic data discard, so the database file does not reach its limit size.\u00a0 If necessary, you can change the current database to SQL Server or Oracle, which have more storage capacity.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Question: In an application, I need to record the values of 25 variables in an Access database to be loaded by an E3Chart. Which of the options below is the…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[735],"tags":[],"yoast_head":"\nKB-27358: Databases vs. Tables vs. Fields. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-27358: Databases vs. Tables vs. Fields.\" \/>\n<meta property=\"og:description\" content=\"Question: In an application, I need to record the values of 25 variables in an Access database to be loaded by an E3Chart. Which of the options below is the…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:38:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-07T20:10:51+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"KB-27358: Databases vs. Tables vs. Fields.\",\"datePublished\":\"2019-03-25T20:38:33+00:00\",\"dateModified\":\"2023-03-07T20:10:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/\"},\"wordCount\":128,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/\",\"url\":\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/\",\"name\":\"[:pt]KB-27358: Databases vs. Tables vs. Fields.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:38:33+00:00\",\"dateModified\":\"2023-03-07T20:10:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-27358: Databases vs. Tables vs. Fields.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-27358: Databases vs. Tables vs. Fields. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-27358: Databases vs. Tables vs. Fields.[:] - Elipse Knowledgebase","og_description":"Question: In an application, I need to record the values of 25 variables in an Access database to be loaded by an E3Chart. Which of the options below is the…","og_url":"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:38:33+00:00","article_modified_time":"2023-03-07T20:10:51+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"KB-27358: Databases vs. Tables vs. Fields.","datePublished":"2019-03-25T20:38:33+00:00","dateModified":"2023-03-07T20:10:51+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/"},"wordCount":128,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/","url":"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/","name":"[:pt]KB-27358: Databases vs. Tables vs. Fields.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:38:33+00:00","dateModified":"2023-03-07T20:10:51+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/kb27358-databases-vs-tables-vs-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-27358: Databases vs. Tables vs. Fields."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2211"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=2211"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2211\/revisions"}],"predecessor-version":[{"id":14327,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2211\/revisions\/14327"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=2211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=2211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=2211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}