File size and fragments

  • 1
  • Question
  • Updated 3 weeks ago
Hello,
Does excessive DB File fragments cause corruption of responsiveness issues?
How many DB File fragments are reasonable?
How does one reduce these?

Here is what I have: 




I am trying to avoid starting a new company file, which in my limited view is the most perverse action I could take. I fail to comprehend why I need to interrupt 9 years of business data for anything short of a catastrophe...


Thanks in advance
Simon



Photo of Simon Denham

Simon Denham

  • 162 Points 100 badge 2x thumb

Posted 4 weeks ago

  • 1
Photo of Rav

Rav, Community Manager

  • 105,244 Points 100k badge 2x thumb
Hi Simon,
We generally advise not more than 50 DB file fragments in a company file. 
Do you usually perform maintenance on your company file? If not, its something I'd highly recommend that you start implementing into your routines and in particular, the steps outlined in the below article as a starting point -
How to improve the performance of your company file
Photo of Bruce

Bruce

  • 3,266 Points 3k badge 2x thumb
Rav
Has the Knowledge Base been restructured?   

I went to save this article on my "knowledge base - saved items" page kb.reckon.com//bookmarks only to be re-directed to help.reckon.com

Assuming it has changed, how do I recover my bookmarks?  

thanks

Bruce
Photo of Bruce McRae

Bruce McRae

  • 222 Points 100 badge 2x thumb
Is that relevant to RAH??
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,496 Points 20k badge 2x thumb
Two points..looks like file hasn't been rebuilt for nearly a year? And how bout is .tlg file?
Resort lists, backup with full verify, rebuild x 3 times..check that tlg file has gone back to small kbs..

Photo of Simon Denham

Simon Denham

  • 162 Points 100 badge 2x thumb
Hello Rav,

Following the guidance provided:

5.    Print Forms have long queues of unprinted transactions that are never to be printed. 

Clear the queues – print to a PDF printer until all queues eliminated

How are the forms cleared from the queues? it is not clear whether these forms are in a queue or just part of the ledger than can be printed when selected.
I have printed all the forms to pdf and they still appear in the list next time, so I am unsure whether I am clearing a queue or not. Or am I missing something obvious.

Simon

Photo of Simon Denham

Simon Denham

  • 162 Points 100 badge 2x thumb
Hello Linda,

The .tlg file is larger than the .qbw file.

I'll follow the steps and post back.
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,496 Points 20k badge 2x thumb
Aha! Once you clear that (backup with verify will do this) you will notice a marked improvement in performance!
Photo of Simon Denham

Simon Denham

  • 162 Points 100 badge 2x thumb
Hello,

I resorted lists, created and restored a portable file to a new working folder.
The .tlg file is now 1344KB.

This is what I have now:


I will follow the other guidance notes and post back with a final screenshot.
From what i understand, we have been backing up, but not then using the backup as the working copy, just continuing using the current file. I feel I have averted a train wreck.
(Edited)
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 57,804 Points 50k badge 2x thumb
Have you tried creating a portable back up and restoring to the default location? It can help to reduce the file size. 
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,496 Points 20k badge 2x thumb
Photo of Simon Denham

Simon Denham

  • 162 Points 100 badge 2x thumb
It seems much better now, although I remain jaded about how anchored this software is in Win98. I'd pay more for a less clunky accounting package.