Slow query performance

Ticketclosed

Kenmure Business Telecom · Slow query performance

Alan Rennie reported slow performance on complex queries. Bethan Lister found they were running complex joins across connectors during nightly refresh, hitting memory limits. She made optimisations to query processing. Closed 7 March 2026.

Priority low

made from

What happened

What this says

As at Fri 9 Oct 2026

Alan Rennie reported slow performance on complex queries. Bethan Lister found they were running complex joins across connectors during nightly refresh, hitting memory limits. She made optimisations to query processing. Closed 7 March 2026.

Problem: complex queries were running slowly, especially during nightly refresh. Handling: Bethan investigated query logs, identified memory bottlenecks during concurrent operations, and made optimisations. Escalated to Felix for platform-level investigation. Watch: query performance issues could impact user satisfaction if not fully resolved.

AI · claude-haiku-4-5-20251001 · as at Fri 9 Oct 2026

AImade from

Details

Updated 9 Oct 26

Prioritylow

Statusclosed

Categoryperformance

Channelemail

First response (min)449

Helpdeskmade from

Trail

Public reply · Alan Rennie 11 Feb 2026 09:39
We've got some queries that are taking a long time to complete.
Public reply · Alan Rennie 11 Feb 2026 10:18
Is there anything on your side that could be slowing things down?
Public reply · Bethan Lister 11 Feb 2026 11:52
Hi Alan, thanks for flagging that. I can help investigate. Can you tell me which specific queries are running slow? And roughly how long they're taking?
created · Alan Rennie 11 Feb 2026 14:04
Hi team, we're noticing the brain is quite slow when we run complex queries. Sometimes it takes a while to get results back. Can you look into this?
Internal note · Bethan Lister 11 Feb 2026 14:30
Looking at the query logs. Account is running complex joins across multiple connectors during the nightly refresh. Hitting memory limits. May need to optimise the data model or batch queries differently. Escalating to Felix.
Public reply · Bethan Lister 11 Feb 2026 21:33
Hi Alan, I've had a look at your query patterns. You're running some quite complex queries which can take time while the nightly refresh is happening. I've made a couple of optimisations to how we're processing those. Can you give it a try tomorrow morning and let me know if it's faster? Thanks, Bethan
Status change · Bethan Lister 3 Mar 2026 15:44
Status change · 7 Mar 2026 23:59

Helpdeskmade from

BG-Demo is a fictional company; every organisation and person here is invented. B-Glass is the tool. Data as of Fri 9 Oct 2026. Help & Support

Help & Support

Open as a page

Help & Support

B-Glass is one place to read everything the company knows about its customers: the CRM, calls, emails, support tickets, product usage, invoices, documents, news and HR. Every page is built from those systems and the data is current to Fri 9 Oct 2026.

How to use the site

Summary is the landing page: what happened this week, the calls just held and the calls coming up, the risks and the renewals due.
Organisations lists every customer. Open one to see its key facts, the AI assessment and next step, platform usage, the ARR journey, deals, documents, contacts and activity, and the lineage of every block.
Conversations, Commercial, People, News and Documents cut the same data by topic. System explains how the site is built and where each figure comes from.
Every card ends with a small made from link: it opens the lineage explorer focused on that card, so you can walk from the figure down to the raw rows it came from.
Use the sun and moon button at the top right to choose dark or light. Choose your device's own mode again to go back to following the device.

How to ask

Press Ask B (the speech bubble) in the header, or open the Ask B page. Type a question, or pick one of the suggestions.

Ask B sends your question to Claude through the B-Glass connector. Claude answers from the same records as these pages, read-only, and links each claim to its source page.
Find (the box in the header) finds the organisations, people, calls, emails, tickets, documents and news that match your words, with links to their pages.
The same connector works in Claude Desktop or the B-Glass Claude Project, with the same answers and sources.

What the data covers

Data	Records
Organisations	225
People at customers	862
BG-Demo staff records (in post and leavers)	58
Calls	1,995
Email threads	3,013
Support tickets	1,159
Documents	1,218
Deals	315
Invoices	285
Events	49
News items	119

Data as of Fri 9 Oct 2026. Text marked AI was written by the AI from the records listed in its made-from link; an AI output that cannot cite its evidence is refused and the previous text kept. Where two systems disagree (for example a contract and the CRM), the key facts show both values and mark the difference.

BG-Demo is a fictional company: every organisation, person and figure here is invented for this demonstration. B-Glass is the tool that reads its data.

Who to contact

Email info@b-glass.uk or talk to your B-Glass account team. Tell us the page address and what looked wrong; a screenshot helps.

Help