#ask-questions
Title
# ask-questions
j
jolly-raincoat-49731
10/02/2023, 2:59 PMGood morning. We have GrowthBook setup using GA4/BigQuery. Our initial A/A test finally started seeing data after having some issues on the Google side of things. However, trying to view the experiment results is causing some issues. When I try to update the data in the experiment's results tab, it just hangs and I can't even cancel it. Our OPS tested the actual queries over at Big Query and they worked without any issues. Is there some troubleshooting we can go through to fix this? Thanks!
f
fresh-football-47124
10/03/2023, 8:36 AM
Are you using the self hosting or cloud?
j
jolly-raincoat-49731
10/03/2023, 1:01 PMSelf hosting
It seems to also hiccup and have failed to fetch errors like these two screenshots.
Screenshot 2023-10-03 at 10.32.10 AM.png,Screenshot 2023-10-03 at 10.35.29 AM.png
f
fresh-football-47124
10/03/2023, 3:39 PM
the failed to fetch error would be throwing an error in the API container’s log
(or its not running)
j
jolly-raincoat-49731
10/03/2023, 3:40 PMOk, I will pass that along to our OPS.
If we have more than 2 metrics, it seems to also break the page. Is that something we have to pay extra for?
f
fresh-football-47124
10/09/2023, 7:03 PM
no
how do you mean break?
j
jolly-raincoat-49731
10/09/2023, 7:04 PMThe update data for experiment results would just sit for hours. I believe we have it figured out. We updated to the latest revision and added some more CPU/RAM to the cluster on Amazon.
f
fresh-football-47124
10/09/2023, 7:05 PM
okay, do you have a lot of data?
you might want to see if you can add an index to some of the columns that would allow the db to optimize the query
j
jolly-raincoat-49731
10/09/2023, 7:05 PMWe get a fair amount of traffic, so yeah.
f
fresh-football-47124
10/09/2023, 7:05 PM
we have some big performance improvements coming in the 2.5 release
j
jolly-raincoat-49731
10/09/2023, 7:06 PMOk cool. I'll pass that along to our OPS team and when it hits, we'll be sure to update!
3 Views