Bug 441666

Summary:	Operations on a Skrooge file with many movements take some time to complete
Product:	[Applications] skrooge	Reporter:	xdmx <xdmx>
Component:	general	Assignee:	Guillaume DE BURE <guillaume.debure>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	stephane
Priority:	NOR
Version First Reported In:	2.25.0
Target Milestone:	25.1.0
Platform:	Arch Linux
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description xdmx 2021-08-28 18:54:36 UTC

SUMMARY
First of all thank you for your work, I've been using Skrooge for the last 10+ years and I'm deeply grateful for it.

Because I've been using it for that long I have many accounts (~40) and movements (~5000) saved in my Skrooge file, which I all point after I check and confirm them.

The problem is that every time I add a new movement it takes a little bit to recalculate the balance that it's shown in the status bar, and when I point the movement everything freezes for a little bit until it completes.


STEPS TO REPRODUCE
1. Create many movements & accounts
2. Check the speed of adding new movements / updating them / pointing

OBSERVED RESULT
It appears to slow down with many movements

EXPECTED RESULT
It should be snappier :)

SOFTWARE/OS VERSIONS
Linux/KDE Plasma: Arch 5.13.12
KDE Plasma Version: 5.22.4
KDE Frameworks Version: 5.85
Qt Version: 5.15.2

Comment 1 Stephane MANKOWSKI 2021-10-30 10:13:07 UTC

Hi,

My skrooge file has:
- Operation since 2004
- 13800 operations
- 14679 suboperations
- 27 accounts

And I don't have this kind of issue.

Could you help me to investigate ?

When you say "freezes for a little", what does it mean ? 1s? 5s? 10s? More?

Are you able to reproduce this issue with an anonymized file (see Tools / Anonymize) ?
If YES, could you provide me this anonymized file ?

If NO, could you follow this process to generate traces ?
For a console:
- export SKGTRACESQL=1000
- skrooge > t.txt
- Replay your scenario
- Send me the t.txt file

For information, this allow to display SQL orders taking more than 1000 ms (1s).

Thank you in advance for your help.

Comment 2 Bug Janitor Service 2021-11-14 04:39:10 UTC

Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!

Comment 3 Bug Janitor Service 2021-11-29 04:38:39 UTC

This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!