{"id":121,"date":"2014-03-01T16:15:02","date_gmt":"2014-03-01T16:15:02","guid":{"rendered":"http:\/\/blog.paralleluniverse-inc.com\/?p=121"},"modified":"2022-03-07T15:24:58","modified_gmt":"2022-03-07T15:24:58","slug":"new-parallel-network-query-distributed-query-makes-fast-join-of-tables-from-multiple-servers","status":"publish","type":"post","link":"https:\/\/blog.paralleluniverse-inc.com\/?p=121","title":{"rendered":"NEW Parallel Network Query (Distributed Query) makes Fast Join of Tables from Multiple Servers"},"content":{"rendered":"<p>Under Parallel Network Query, servers are numbered according to the table join<br \/>\norder of query (forming server pipeline) and each server processes its own<br \/>\ntables.\u00a0 Query result is generated by concatenating processed tables of each<br \/>\nserver along the server pipeline.<\/p>\n<p>Parallel Network Query may also be used to speed up slow server by distributing<br \/>\ntables of the query to multiple servers for processing which effectively<br \/>\naggregates server resources (such as disk I\/O bandwidth and CPU\/cores).<\/p>\n<p>See Technology and Benchmarks page.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Under Parallel Network Query, servers are numbered according to the table join order of query (forming server pipeline) and each server processes its own tables.\u00a0 Query result is generated by concatenating processed tables of each server along the server pipeline. Parallel Network Query may also be used to speed up slow server by distributing tables [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=\/wp\/v2\/posts\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=121"}],"version-history":[{"count":5,"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":126,"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=\/wp\/v2\/posts\/121\/revisions\/126"}],"wp:attachment":[{"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.paralleluniverse-inc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}