基于gemFire的SQLFire测试

〇〇

虽然没有计时，但in子查询还是很慢
1048576 rows inserted/updated/deleted
sqlf> insert into t2m select * from t1m;
1048576 rows inserted/updated/deleted
sqlf> select count(*) from t1m where expr in(select expr from t2m);

〇〇

〇〇 发表于 2014-4-8 21:01
虽然没有计时，但in子查询还是很慢
1048576 rows inserted/updated/deleted
sqlf> insert into t2m selec ...

运行了3天，结果终于出来了，中间按了很多次ctrl+c也没能中断
sqlf> select count(*) from t1m where expr in(select expr from t2m);
1
-----------
1048576

1 row selected

〇〇

终于找到计时命令了
加上索引，一下变快
sqlf> create index i2m on t2m(expr);
0 rows inserted/updated/deleted
sqlf> ELAPSEDTIME  on;
sqlf> select count(*) from t1m where expr in(select expr from t2m);
1
-----------
1048576

1 row selected
ELAPSED TIME = 4728 milliseconds

苗德舜

写的不错，mark留名！

〇〇

终于执行完了
sqlf> select count(*) from t1m where expr is not null and expr in(select expr from t2m where expr is not null);
1
-----------
1048576

1 row selected
ELAPSED TIME = 4755 milliseconds
sqlf> select count(*) from t1m where expr not in(select expr from t2m);
1
-----------
0

1 row selected
ELAPSED TIME = 249138941 milliseconds
sqlf>

〇〇

SQL> select  249138941/1000/3600/24 from dual;

249138941/1000/3600/24
----------------------
            2.88355256

〇〇

下载链接

Pivotal SQLFire Red Hat 6 RPM *	1.1.2	Apr 04, 2014	45 MB	Minor release
	Pivotal SQLFire  Red Hat 5 RPM *	1.1.2	Apr 04, 2014	45 MB	Minor release
	Pivotal SQLFire Debian Installer *	1.1.2	Apr 04, 2014	45 MB	Minor release