Re: Price Editor/Database lag

2018-04-06 Thread DGPickett via gnucash-user
PS: Sometimes, trees of trees/containers outperform having everything in one tree/container. If the quotes for each symbol are in a separate container, the RAM hit to query or churn data for that symbol is minimized. If the data is kept sorted in all storage forms (when inserted into the containe

Re: Price Editor/Database lag

2018-04-04 Thread DGPickett via gnucash-user
I discovered my vm.swappiness=60, dropped it to 10 as recommended for desktop LINUX. Now no si/so on vmstat, but a peak in cs and a moderate delay, around 20 seconds, when adding price quotes. Again, it looks like it is using too big a RAM space to manage this data, or some similar process ineffi

Re: Price Editor/Database lag

2018-04-03 Thread DGPickett via gnucash-user
I started vmstat -tw 11 in a wide xterm and I do see a lot of swap out for some but not all delays. The not-first delays seem to be smaller now. The first delay did 3K+ so, later ones did 2K+, 300+ or almost no so. Almost no so may indicate the container is not dealing well with the volume and r

Re: Price Editor/Database lag

2018-04-02 Thread David via gnucash-user
f C/C++/JAVA/??? -- direct access to VM with memory objects visible to multiple processes by mmap() or file calls, access to all free RAM as your cache. -Original Message- From: David To: jralls Cc: gnucash-user Sent: Mon, Apr 2, 2018 11:30 am Subject: Re: Price Editor/Database lag I

Re: Price Editor/Database lag

2018-04-02 Thread David via gnucash-user
ubject: Re: Price Editor/Database lag Entirely possible. I’m not too familiar with the GtkTreeList implementation. Regards, John Ralls On Apr 1, 2018, at 6:59 PM, David wrote: John, OK, that makes sense, except the lag can occur pretty randomly as I select lists of symbols, select symbols

Re: Price Editor/Database lag

2018-04-02 Thread John Ralls
alls mailto:jra...@ceridwen.us>> > > To: David mailto:dgpick...@aol.com>> > > Cc: Gnucash Users > <mailto:gnucash-user@gnucash.org>> > > Sent: Sun, Apr 1, 2018 3:48 pm > > Subject: Re: Price Editor/Database lag > > > > Please remember to co

Re: Price Editor/Database lag

2018-04-01 Thread David Carlson
the most > recent month end nav so it is cloned with the add, just needs a new date > and price.) Maybe it is going into thrashing? > > > > Thanks, > > > > David > > > > > > -Original Message- > > From: John Ralls > > To: David

Re: Price Editor/Database lag

2018-04-01 Thread John Ralls
nal Message- > From: John Ralls > To: David > Cc: Gnucash Users > Sent: Sun, Apr 1, 2018 3:48 pm > Subject: Re: Price Editor/Database lag > > Please remember to copy the list on all replies. > > The data file is read exactly once, when it's loaded. After that ev

Re: Price Editor/Database lag

2018-04-01 Thread David via gnucash-user
price.) Maybe it is going into thrashing? Thanks, David -Original Message- From: John Ralls To: David Cc: Gnucash Users Sent: Sun, Apr 1, 2018 3:48 pm Subject: Re: Price Editor/Database lag Please remember to copy the list on all replies. The data file is read exactly once

Re: Price Editor/Database lag

2018-04-01 Thread John Ralls
ache of > public data, and can be shared with all if they use the same key symbols, > updated once for all sets of books! > > > > -Original Message- > From: John Ralls > To: DGPickett > Cc: gnucash-user > Sent: Sun, Apr 1, 2018 9:39 am > Subject: Re: P

Re: Price Editor/Database lag

2018-04-01 Thread John Ralls
> On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user > wrote: > > Since I was collecting prices daily, I guess my price database is pretty > large, and my family finances are in there for about 5 years. I have xml > database, and compressed, but I checked my save intervals, even increased

Re: Price Editor/Database lag

2018-04-01 Thread DGPickett via gnucash-user
Since I was collecting prices daily, I guess my price database is pretty large, and my family finances are in there for about 5 years. I have xml database, and compressed, but I checked my save intervals, even increased them, but no help. My PC has 8 GB ram, and a very large solid state swap driv

Re: Price Editor/Database lag

2018-03-31 Thread farleykj
You don't necessarily have to update manually. The original Yahoo source has been ruined, but you can (and I do) use "yahoo_json" as a source. It's worked fine for me. As for your actual question, I'm sorry but I've no idea. I'm running on Mac OSX. People might have some inquiries about the particu

Price Editor/Database lag

2018-03-31 Thread David G. Pickett
Now that I am manually updating my stocks monthly, thanks, Yahoo, I find that as I pull up the price history to clone a new month end entry for the symbol, I get a _*long (30 second) gray out delay*_ (on Linux, and not the newest PC) at some point in the cycle, like a premature auto save or som