hello! can you help please can we somehow change ...
# ask-questions
a
hello! can you help please can we somehow change timeout settings for queries in the analytics section?
f
What are you experiencing? We don't have a timeout that I can think of- it might be on your DB side. How long are the queries running for?
a
sometimes we get timeout errors when calculating metrics or adding Fact Tables we thought that there are some internal Growthbook timeouts limits thank, we will check our DB settings
g
@fresh-football-47124 I think, I've found, where the timeout (60 seconds) is silently set: Inside the clickhouse client: https://github.com/TimonKK/clickhouse/blob/1e873270cc23a9079f1ac35655257d0b2f61ff68/index.js#L839 Is there a possibility to somehow add a
timeout
parameter to https://github.com/growthbook/growthbook/blob/main/packages/back-end/types/integrations/clickhouse.d.ts#L1 And use them here: https://github.com/growthbook/growthbook/blob/main/packages/back-end/src/integrations/ClickHouse.ts
👍 1
And there is also another problem: now growthbook relies on unofficial clickhouse client clickhouse, which hasn't been maintained for 2 years already 😱 But there is official client @clickhouse/client from the developers of ClickHouse.
f
Hi Andrey - would you mind opening an issue for updating the clickhouse library?
g
@fresh-football-47124 we have large amounts of data and a lot metrics easily take 2-3 minutes to calculate. Can we create a quick PR which increases clickhouse timeout from 60 sec to 300 sec ?