Good morning. We have GrowthBook setup using GA4/B...
# ask-questions
j
Good 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
Are you using the self hosting or cloud?
j
Self 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
the failed to fetch error would be throwing an error in the API container’s log
(or its not running)
j
Ok, 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
no
how do you mean break?
j
The 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
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
We get a fair amount of traffic, so yeah.
f
we have some big performance improvements coming in the 2.5 release
j
Ok cool. I'll pass that along to our OPS team and when it hits, we'll be sure to update!