# Identified another slow query during backup

**URL:** <https://forum.duplicati.com/t/identified-another-slow-query-during-backup/14005>\
**Category:** Support\
**Created:** [February 24, 2022, 6:54pm UTC](https://forum.duplicati.com/t/identified-another-slow-query-during-backup/14005 "2022-02-24T18:54:50Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![ts678](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/t/8491ac/32.png) [@ts678](https://forum.duplicati.com/u/ts678)\
**Post date:** [February 26, 2022, 11:30pm UTC](https://forum.duplicati.com/t/identified-another-slow-query-during-backup/14005/5 "2022-02-26T23:30:07Z")

</div>

> [@tarianjed](#):
>
> Can anyone point me to a in depth explainer on the architecture and database design

I don’t think there’s anything that deep, but there are some additional thoughts about it at

> [@Database rebuild](https://forum.duplicati.com/t/database-rebuild/13884/6):
>
> So, mainly for my future reference, let me summarize all that information:

Followup ensued, original author added some specifics, and I gave my general summary:

> [@Database rebuild](https://forum.duplicati.com/t/database-rebuild/13884/7):
>
> Here’s my (maybe wrong) understanding of things:

[Developer category](https://forum.duplicati.com/c/developer/8) has some other information, e.g. if you want to get into the Channels.

[Channel Pipeline](https://forum.duplicati.com/t/channel-pipeline/11466) might help if concurrency issues in DB handling arise. I suspect they do.

> [@tarianjed](#):
>
> Luckily I am good with databases so I will be following up with some proposed solutions

This is fantastic, as expertise is all too rare. There are others trying, but it’s hard to get into.  
Sometimes I can answer questions based on looking at databases rather than writing SQL.

---

_[View the full topic](https://forum.duplicati.com/t/identified-another-slow-query-during-backup/14005)._