gp借助类DBLINK访问oracle性能测试

gtlions

于 2014-03-26 19:47:27 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/gtlions/article/details/22204957

本文主要测试了Greenplum通过DBLINK访问Oracle数据库时，使用落地文件外部表和不落地的外部表两种方式加载数据的性能。在小数据量下，两者性能差距不大，但随着数据量增加，不落地方式的性能劣势显著，如在100W记录时，速度比落地方式慢约12.9倍。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

0. Oracle测试数据准备:
[oracle@db1 ~]$ sqlplus system/000000

SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 25 10:26:06 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> drop table test ;

Table dropped.

SQL> create table test(id int,name varchar2(20),age int,msg varchar2(20));

Table created.

SQL> insert into test values(1,'aaaaa',1,'aaaaa');

1 row created.

SQL> insert into test values(2,'bbbbb',2,'bbbbb');

1 row created.

SQL> insert into test values(3,'ccccc',3,'ccccc');

1 row created.

SQL> insert into test valu