How to force a SQL++ query to take a long time?

SQL++
1

What’s a good way to force a SQL++ query to take long time?

The use case is testing how the client handles timeouts.

Thanks!

2 
SELECT COUNT (1)  AS cnt
FROM ARRAY_RANGE(0,100000) AS d1,
     ARRAY_RANGE(0,100000) AS d2, 
     ARRAY_RANGE(0,100000) AS d3;

If need add/reduce more join terms or increase/decrease second argument value

1 Like