Profiling - 2023.2 English

The hash join v2 design is validated on Alveo U280 board at 282 MHz frequency. The hardware resource utilizations are listed in the following table.

Table 33 Table 1 Hardware resources for hash join v2

Name	LUT	BRAM	URAM	DSP
Platform	122083	202	0	4
join_kernel	63697	98	64	3
User Budget	1180637	1814	960	9020
Percentage	5.40%	5.40%	6.67%	0.03%

The performance is shown below.

In above test, table Lineitem has 3 columns and 6001215 rows and Orders does 1 column and 227597 rows. This means that the design takes 55.5945ms to process 69.55MB data, so it achieves 1.21GB/s throughput.