Erratic behaviour of databaase.

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
alas
New MMEX User
Posts: 12
Joined: Fri Jun 24, 2016 9:55 am
Are you a spam bot?: No

Erratic behaviour of databaase.

Post by alas »

A variety of problems have occurred for no apparent reason. My database is a relatively new one, starting in January 2019 with fairly average number of transactions. When first opening the database it has suddenly become slow to load, as does each account I select to view. When entering a transaction, the entry responds fairly quickly but the balance take several seconds to update. Also accounts that are marked closed and with the 'favourite account' box unchecked, still show on the home page! All very frustrating. This program has never given me any trouble before. I have removed the program and then reinstalled it but to no effect, Any suggestions.
Thank you
Alasdair

guanlisheng
MMEX Developer
Posts: 209
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Location: China
Contact:

Re: Erratic behaviour of databaase.

Post by guanlisheng »

would you share more information on the concrete version of MMEX? then developers would take a deep look

alas
New MMEX User
Posts: 12
Joined: Fri Jun 24, 2016 9:55 am
Are you a spam bot?: No

Re: Erratic behaviour of databaase.

Post by alas »

The version I am running Is Version 1.3.3 (DBV7). Thank you for your interest.

guanlisheng
MMEX Developer
Posts: 209
Joined: Wed Dec 21, 2011 5:58 am
Are you a spam bot?: No
Location: China
Contact:

Re: Erratic behaviour of databaase.

Post by guanlisheng »

this is weird. is there any clue engineer can follow, such as sqlite database size and rows.

siowena
MVP MMEX User
Posts: 114
Joined: Tue Jul 17, 2018 8:04 am
Are you a spam bot?: No

Re: Erratic behaviour of databaase.

Post by siowena »

Is your DB file on a cloud drive (e.g. OneDrive, iCloud, dropbox, etc.)?

I find sometimes the sync causes MMEX to pause and go slow.

Also, try doing a database cleanup - there's an option on the menu.

alas
New MMEX User
Posts: 12
Joined: Fri Jun 24, 2016 9:55 am
Are you a spam bot?: No

Re: Erratic behaviour of databaase.

Post by alas »

siowena wrote:Is your DB file on a cloud drive (e.g. OneDrive, iCloud, dropbox, etc.)?

I find sometimes the sync causes MMEX to pause and go slow.

Also, try doing a database cleanup - there's an option on the menu.
No it is running on my PC, This has only happened in the last week or so, before it was instant. There is nothing new on my computer and all other software runs normally. I have also done the database cleanup. In addition I have uninstalled the software, ensuring all components have been removed and then re-installed the latest version, which I already had, but still the same problem. Thanks for your interest.

Post Reply