[GNC] GnuCash Delays on KB Input

[Cam Ellison]

On 2025-08-26 10:29, David T. via gnucash-user wrote:
> Given Stan's response on this, I'm imagining the problem lies with 
> something in the data file. In fact, if I open a different file on the 
> machine, the problem appears to have disappeared. So, that supports 
> the idea that there is something wrong with the file.
>
>
> Unfortunately, my data file covers 20 years of information. And yes, 
> I've run Check & Repair on the whole file. I can also eliminate any 
> issue with the gcm file, since I am on a new machine, and the gcm is 
> new (I know this because every account's column settings are defaulted 
> back stock layout. I had set the columns on the old machine).
>
>
> I have absolutely no idea how I would troubleshoot this. Re-entering 
> 20 years of data is not the answer. As for an older backup, I had 
> already held off on bookkeeping for the last six months; going further 
> back would entail manual entry of thousands of transactions, which is 
> really not something I'm prepared to do either.
>
>
> I would scan the raw xml to see if there were something obvious, but I 
> don't even know what I'd be looking for. I am considering exporting 
> the entire file to CSV and then reimporting into a new file,but again, 
> if the problem is some form of corruption in the transaction data, 
> this would just propagate the problem in a new file...
>
>
> I am open to creative suggestions.
>
Are you in a position to switch to a database (postgresql, mysql, 
sqlite)? The problem may be (in part or whole) the sheer size of the 
file, not its contents or structure.

Cheers

Cam