Why the desktop app is so slow

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
alex4998
New MMEX User
Posts: 3
Joined: Mon Sep 23, 2019 6:05 am
Are you a spam bot?: No

Why the desktop app is so slow

Post by alex4998 »

I don't understand how it's even possible to be that slow. It looks like the app is written in C++. I have a QIF file which is just 10111 lines long 108KB. It takes 20 seconds to load/parse the file, just 500 lines per second when each line is short and quite straightforward for parsing. It it only loading and parsing, importing takes another 20 seconds or so. That should take a second. There is nothing complex there. Removing 1800 records from an account takes minutes. I even thought the app hung up, the interface became unresponsive, but no, it actually deleted those records but how much time it took. Is there something that might make the app faster?
christon
New MMEX User
Posts: 1
Joined: Mon Mar 16, 2020 9:23 am
Are you a spam bot?: No

Re: Why the desktop app is so slow

Post by christon »

disable all task program this may help you
mikhailo2608il
Senior MMEX User
Posts: 31
Joined: Tue Jun 12, 2018 3:36 am
Are you a spam bot?: No

Re: Why the desktop app is so slow

Post by mikhailo2608il »

I have almost 4 Gig of data (22,000+ transactions representing my finances since 1993) in the MMB file that MMEX uses and I have no performance issues at all on my Windows PC. Is your file significantly larger than mine ?

I do not understand why your QIF import took so long. When next you do the type of processing that you described in your post you will want to have Task Manager open and be looking at the Performance tab for CPU, Memory, and Disk utilization so that you can hopefully identify where the bottleneck is.

MMEX keeps it's data in a SQLITE database. There are all sorts of variables that can impact performance of the database during mass reads (large queries) or mass writes (voluminous insertions) and a database can be optimized either for reads or writes but not for both at the same time. If you do these mass imports on an frequent basis then you might want to look at optimizing the MMEX database to speed up writes to it.
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Why the desktop app is so slow

Post by Nikolay »

It's open source project.
Post Reply