Brain performance: slow query response times
Ticketclosed
Lindqvarn Retail: documents · Brain performance: slow query response times
Linnea Holm reported slow query response times, particularly when combining data from multiple systems. Investigation showed performance was within expected range for their data volume. Bethan optimized indexes to improve response times.
What happened
What this says
Current to 11 Oct 26Linnea Holm reported slow query response times, particularly when combining data from multiple systems. Investigation showed performance was within expected range for their data volume. Bethan optimized indexes to improve response times.
Problem: Customer experienced multi-minute query times when creating reports combining data across systems.
Handling: Bethan reviewed query logs and found platform responding normally. The slowness was due to dataset size and the number of joined sources, within expected range. She optimized the query index and deployed changes in the nightly refresh.
Watch: This is a perception issue more than a defect. Customer concern about performance could affect adoption if not managed.
Details
Updated 9 Oct 26Trail
public_reply · Linnea Holm 25 Nov 2025 10:08Hi, yes we've also been tracking this. We did some test queries and it seems the performance is worst when we're joining data from multiple systems together. I'd appreciate any help with optimising that.- internal_note · Bethan Lister 25 Nov 2025 11:12Checked logs, platform responding normally. Could be source sync delay or index freshness issue. Need to check source refresh times and query execution plan.
- created · Linnea Holm 25 Nov 2025 12:41Hi, we've been noticing some performance issues with the brain when running larger queries and building dashboards. I was trying to create a report that combines customer feedback from the past year across all our data sources, and the query took several minutes to complete. This is affecting how quickly our teams can work. Could you help us investigate if this is a normal load, or if there's something we can optimise on our end?
- public_reply · Bethan Lister 25 Nov 2025 14:08Hi Linnea, thanks for that context. I've reviewed your recent queries and the platform is responding normally on its end. The slowness is coming from the dataset size you're working with. Given your data volume and the number of joined sources, the query time is within expected range. Let me run some optimisations on the index and see if I can improve it for you.
- public_reply · Bethan Lister 25 Nov 2025 20:35I've optimised the index for your largest queries. Can you try running that dashboard report again and let me know what response times you're seeing? The changes will be live in tonight's refresh.
- status_change · 5 Dec 2025 23:59