Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is database reorganization, and how should I do it in Timber?

0
10 Posted

What is database reorganization, and how should I do it in Timber?

0
10

Timber provides update functionality by extending the XQuery language. When no updates have been performed on a Timber volume, all nodes for a document are laid out on the disk in document order. This is a key factor in efficient query execution. When updates are performed we may be required to put nodes into a separate unordered overflow portion of the file. This happens when we insert new nodes, and when when a node is modified so that its new value is larger than its previously stored value. If the overflow portion is large enough, query performance will suffer. To alleviate this problem, Timber provides a reorganize function that will take a file containing an overflow portion, and lay all of the nodes out on disk in document order.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123