Are there ever situations where data fragmentation grows and can lead to performance degradation? If so, is there a way to completely rewrite the data into an un-fragmented version? Many operations in one of my databases seem very slow in the last two days, so I am looking for a solution.
No, there is no such thing as data fragmentation in Panorama. The data is always kept in a single continuous block of RAM.
Something was awry in my database. I exported all the data, deleted all the records, and then imported the data. The time to produce a report went from 30 seconds to 9 seconds.