Hi, I should clarify that when I mean transactions I am referring to double entries. Each business transaction, from the e-commerce stuff I do, outputs on average five double entries: one each for sales, commissions, shipping, coupons and so on.
So 500k double entries would yield around 100k actual business transactions over 3 or so years. The software is not slow to the point of being non-functional or a even frustration. It is only that I prefer a tad bit more sprightliness. Also it seems to run perfectly well on my relatively slower laptop which just has 6GB of RAM. Noted about the loading of transactions to memory. I will keep a closer eye on the memory footprint. Unfortunately my programming experience is limited to VBA on MS Excel. I have sadly not worked with apps, and with databases only very little. I am not sure how I could contribute to the development over someone with actual database experience. Thanks, Rizwan On Mon, Nov 18, 2019, 11:21 AM D <sunfis...@yahoo.com> wrote: > Rizwan, > > I am intrigued. You say you're a new user, but you have 500,000 > transactions. Wow! > > You've been getting the usual kinds of responses to your question: how > fast is your computer, how many reports are you running, be patient, don't > close Gnucash, etc. > > But it sounds as if you're pushing boundaries that most of us > personal/small business users aren't. For example, my data file loads and > runs pretty well. It covers over ten years of transactions, and the last > time I checked, it was around 200,000 transactions all told. It may be that > you are an outlier user who tests the functional limits of Gnucash. > > One major issue that has long been known is that the software is not built > to think like a database app. It loads the entire data file into memory on > start up. It does this even with the SQL back ends, which is a roundabout > way to tell you that changing to a database back end won't help at this > time, sadly. > > I see that you had another query about transaction imports that suggests > that you have some programming experience. Many of us would cheer if you > were to put that experience to work helping the small development team. One > really big area they are looking at is the migration of Gnucash to a true > db app--a long term goal, to be sure, since there are so many immediate > issues that need to be addressed. > > Cheers, > David T. > > On November 18, 2019, at 8:17 AM, David Carlson < > david.carlson....@gmail.com> wrote: > > There is a setting under Edit > Preferences > General to compress the data > file. I think it is selected by default. In Windows 10 compression > happens very fast so that is not likely to be an issue with speed. > > However, because the entire database is [theoretically] in RAM, at some > point that will cause RAM to spill over into swap space on the local > drive. Then things really slow down. This will happen more quickly if a > web browser is running concurrently. In Windows open the Task Manager and > look under performance to see how your machine is doing. > > David Carlson > > On Sun, Nov 17, 2019 at 8:14 PM M. Rizwan Muzzammil <m.riz...@gmail.com> > wrote: > > > I will check. Thanks for the suggestion. > > > > On Mon, Nov 18, 2019, 10:06 AM Greg Feneis <mfen...@gmail.com> wrote: > > > > > It seems like there used to be an option to encrypt, or zip the working > > > file when it's the default xml type. If that's still an option, and is > > > enabled, it could cause a delay relative to the file size > > > > > > Kind regards, Greg Feneis > > > (Pixel 3) > > > > > > > > > On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil <m.riz...@gmail.com> > > > wrote: > > > > > > > Thanks for your reply....I am using the default file types. Does it > > make > > > a > > > > difference if I change? > > > > If so to what other type and how can it be done? > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > > If you are using Nabble or Gmane, please see > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > > ----- > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > > -- > David Carlson > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
