Page 1 of 1

Large database and slow responsiveness

Posted: 10 August 2009, 11:48
by bikemunkey
I admit I have quite a large database of all my current and previous accounts. I suppose one answer to the problem I am about to describe could be averted by splitting off the DB into smaller files (on a yearly basis, for example). But, I'd rather not do this. Anyway, iCompta is certainly no horse but when I am scrolling my transactions it certainly doesn't feel smooth. Tabbing between the different fields on the right (Date, Amount etc.) isn't instant either and takes a fraction longer than one would expect.

It certainly isn't problematic enough for me to switch to another application as I love the rest of what iCompta offers. However, is there any other way (i.e. aside from splitting my DB) that can improve the responsiveness of iCompta? Or is there a plan for future optimisation?

FYI, my database goes back about 5-6 years on accounts that were and are frequently used (i.e lots of transactions).

Re: Large database and slow responsiveness

Posted: 10 August 2009, 11:57
by Angeman
Could you send me your file at cyril.anger@lyricapps.com so that I can debug and optimize ? Thanks

Re: Large database and slow responsiveness

Posted: 10 August 2009, 12:06
by bikemunkey
Yes, no problem. Although this will have to be a little later on today when I can get back to my personal computer! But thanks. :)

Re: Large database and slow responsiveness

Posted: 27 May 2013, 16:50
by kanataheikou
Hi Angeman, I use iCompta 4.0.11 on OSX 10.6.8. The file size is about 4.2MB. Recent days, iCompta becomes slow down when I clicked some accounts. Could you optimise my file or advise to me?

Re: Large database and slow responsiveness

Posted: 01 June 2013, 15:34
by Angeman
Sure can you send me your file by email ?

Re: Large database and slow responsiveness

Posted: 02 June 2013, 17:25
by kanataheikou
Yes, sure! I have sent an e-mail. Thanks!