2022-09-07 mysql/stonedb-TPCH-Q20语句测试

悟世者

已于 2023-06-16 18:05:29 修改

阅读量256

点赞数

CC 4.0 BY-SA版权

于 2022-09-07 15:55:41 首次发布

本文链接：https://blog.youkuaiyun.com/adofsauron/article/details/126747491

stonedb 专栏收录该内容

163 篇文章 ¥9.90 ¥99.00

订阅专栏

超级会员免费看

该博客对比了StonedB和MySQL8在执行TPCH Q20语句时的性能，结果显示StonedB耗时7秒，而MySQL8耗时长达5分钟25秒，且两者查询结果为空。

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

摘要:

对TPCH的Q20语句进行测试, 并与MySql8/innodb做对比

Q20语句

select
	s_name,
	s_address
from
	supplier,
	nation
where
	s_suppkey in (
		select
			ps_suppkey
		from
			partsupp
		where
			ps_partkey in (
				select
					p_partkey
				from
					part
				where
					p_name like 'forest%'
			)
			and ps_availqty > (
				select
					0.5 * sum(l_quantity)
				from
					lineitem,partsupp
				where
					l_partkey = ps_partkey
					and l_suppkey = ps_suppkey
					and l_shipdate >= date '1994-01-01'
					and l_shipdate < date '1994-01-01' + interval '1' year
			)
	)
	and s_nationkey = n_nationkey
	and n_name = 'CANADA'
order by
	s_name;