{"id":2384,"date":"2015-04-29T21:19:15","date_gmt":"2015-04-29T13:19:15","guid":{"rendered":"http:\/\/blog.qdac.cc\/?p=2384"},"modified":"2015-04-30T08:40:00","modified_gmt":"2015-04-30T00:40:00","slug":"postgresql-%e7%9b%b4%e8%bf%9e%e6%80%a7%e8%83%bd%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/blog.qdac.cc\/?p=2384","title":{"rendered":"[QDB]PostgreSQL \u76f4\u8fde\u6027\u80fd\u6d4b\u8bd5"},"content":{"rendered":"<p>QDAC.QDB \u7684 PostgreSQL \u76f4\u8fde\u6a21\u5757\u76ee\u524d\u5df2\u7ecf\u5b8c\u6210\u4e8670%\u5de6\u53f3\u529f\u80fd\u7684\u5f00\u53d1\uff0c\u6240\u4ee5\u5c31\u505a\u4e86\u4e00\u4e2a\u4e0e\u5176\u5b83\u80fd\u591f\u8fde\u63a5 PostgreSQL \u6570\u636e\u5e93\u7684\u7ec4\u4ef6\u7684\u6027\u80fd\u5bf9\u6bd4\u6d4b\u8bd5\uff0c\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n<p>\u8fde\u63a5\u521d\u59cb\u5316\u7684\u65f6\u95f4\u6211\u6ca1\u6709\u8fdb\u884c\u7edf\u8ba1\uff0c\u6211\u4eec\u6d4b\u8bd5 QDAC\u3001UniDAC\u3001FireDAC \u4e09\u8005\u6267\u884c\u76f8\u540c\u811a\u672c\u6240\u6709\u7684\u65f6\u95f4\uff0c\u4ee5\u89c2\u5bdf\u5176\u76f8\u5e94\u7684\u6548\u7387\u5bf9\u6bd4\uff0c\u4e3a\u4e86\u5c06\u7f51\u7edc\u6709\u5f71\u54cd\u964d\u4f4e\u5230\u6700\u4f4e\uff0c\u6211\u5728\u672c\u673a\u7279\u610f\u5b89\u88c5\u4e86 PostgreSQL 9.4.1 \u6765\u505a\u6d4b\u8bd5\u3002<\/p>\n<p><strong>\u3010Select \u6d4b\u8bd5\u3011<\/strong><\/p>\n<p>\u4ece\u540c\u4e00\u4e2a\u6570\u636e\u96c6\u4e2d\u53d6\u4e0d\u540c\u6570\u91cf\u7684\u8bb0\u5f55\uff08\u4ece10000\u6761\u5f00\u59cb\uff0c\u6bcf\u6b21\u500d\u589e\uff0c\u603b\u8ba1\u670920\u4e07\u6761\u8bb0\u5f55\uff0c\u7ed3\u679c\u5355\u4f4d\u4e3ams\uff09\uff1a<\/p>\n<table class=\" aligncenter\" width=\"288\">\n<tbody>\n<tr>\n<td>\u6761\u6570<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">QDAC<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">UniDAC<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">FireDAC<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400;\" width=\"72\">10000<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">16<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">31<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">31<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400;\" width=\"72\">20000<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">32<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">62<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">47<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400;\" width=\"72\">40000<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">63<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">94<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">78<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400;\" width=\"72\">80000<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">110<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">203<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">172<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400;\" width=\"72\">160000<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">218<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">391<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">391<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400;\" width=\"72\">200000<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">313<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">500<\/td>\n<td style=\"font-weight: 400;\" width=\"72\">625<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: left;\">\u4ece\u4e0a\u9762\u7684\u7ed3\u679c\u770b\uff0c\u968f\u7740\u6570\u636e\u91cf\u7684\u589e\u5927\uff0cQDAC\u7684\u6027\u80fd\u4f18\u52bf\u9010\u6e10\u663e\u73b0\uff0c20\u4e07\u6761\u8bb0\u5f55\u65f6\uff0c\u6027\u80fd\u5df2\u7ecf\u4e0e UniDAC \u548c FireDAC \u62c9\u5f00\u4e86\u8ddd\u79bb\u3002<\/p>\n<p style=\"text-align: left;\"><strong>\u3010\u6279\u91cf\u6267\u884c\u811a\u672c\u6d4b\u8bd5\u3011<\/strong><\/p>\n<p style=\"text-align: left;\">\u7531\u4e8e UniDAC \u4e0d\u652f\u6301\u76f4\u63a5\u6279\u91cf\u6267\u884c\u811a\u672c\uff0c\u800c\u7528 UniScript \u6267\u884c\u811a\u672c\u65f6\uff0c\u5b83\u662f\u7531\u81ea\u5df1\u62c6\u5206\u6210\u4e00\u6761\u6761SQL\u9001\u5230\u670d\u52a1\u5668\u7aef\u6267\u884c\uff0c\u6240\u4ee5\u6548\u7387\u5f88\u5dee\uff0c\u5728\u6b64\u5c31\u4e0d\u4e0e\u5176\u5bf9\u6bd4\u3002\u800c FireDAC \u901a\u8fc7\u8bbe\u7f6e DirectExecute \u53c2\u6570\u53ef\u4ee5\u76f4\u63a5\u6267\u884c\uff0c\u6240\u4ee5\u5bf9\u6bd4\u5c31\u662f QDAC \u548c FireDAC \u4e24\u8005\u4e4b\u95f4\u8fdb\u884c\uff0c\u5b9e\u9645\u5404\u63d2\u516510\u4e07\u6761\uff0c\u5b9e\u6d4b\u5bf9\u6bd4\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n<ul>\n<li style=\"text-align: left;\">QDAC\u00a0:\u00a07031 ms<\/li>\n<li style=\"text-align: left;\">FireDAC : 8125ms<\/li>\n<\/ul>\n<p>QDAC \u6bd4 FireDAC \u901f\u5ea6\u5feb\u7ea6 13.5%\u3002<\/p>\n<p><strong>\u3010\u4fdd\u5b58\u5230\u5185\u5b58\u6d41\u6d4b\u8bd5\u3011<\/strong><\/p>\n<p>\u800c\u5c06\u6570\u636e\u4ece\u6570\u636e\u5e93\u8f6c\u6362\u5230\u6587\u4ef6\u6d41\u4e2d\uff0cUniDAC \u53ea\u652f\u6301 XML\uff0c100000 \u6761\u8bb0\u5f55\u6d4b\u8bd5\uff0cQDAC\u3001UniDAC \u548c FireDAC \u7684\u6bd4\u8f83\u7ed3\u679c\u5206\u522b\u662f 750\u30012390\u3001625 ms\uff0cQDAC \u7684 Converter \u6682\u65f6\u5c45\u4e2d\uff0c\u5c06\u6765\u901a\u8fc7\u8fdb\u4e00\u6b65\u4f18\u5316\u5e94\u8be5\u53ef\u4ee5\u8fdb\u4e00\u6b65\u63d0\u5347\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>QDAC.QDB \u7684 PostgreSQ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[69,8,9,66],"tags":[117,229],"class_list":["post-2384","post","type-post","status-publish","format-standard","hentry","category-c-builder","category-delphi","category-qdac","category-qdb","tag-117","tag-229"],"views":5820,"_links":{"self":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/2384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2384"}],"version-history":[{"count":5,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/2384\/revisions"}],"predecessor-version":[{"id":2390,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/2384\/revisions\/2390"}],"wp:attachment":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}