2021-01-28 GnuCash IRC logs
00:21:27 *** Mechtilde has joined #gnucash
01:08:27 *** frakturfreak has quit IRC
01:22:32 *** frakturfreak has joined #gnucash
01:22:32 *** ChanServ sets mode: +v frakturfreak
01:41:51 *** sbluhm has joined #gnucash
01:41:51 *** ChanServ sets mode: +v sbluhm
01:58:20 *** guiu has quit IRC
02:01:14 *** fell has quit IRC
02:02:33 *** fell has joined #gnucash
02:02:33 *** ChanServ sets mode: +o fell
02:28:12 *** Unhammer has joined #gnucash
02:30:46 *** roxart has joined #gnucash
02:37:31 *** storyjesse has quit IRC
02:41:42 *** storyjesse has joined #gnucash
02:46:55 *** gjanssens has joined #gnucash
02:46:56 *** ChanServ sets mode: +o gjanssens
03:44:50 *** Mechtilde has quit IRC
03:48:54 *** Mechtilde has joined #gnucash
04:09:38 *** storyjesse has quit IRC
04:20:04 *** mikee has quit IRC
04:21:22 *** mikee has joined #gnucash
04:21:22 *** ChanServ sets mode: +o mikee
04:29:52 *** Aussie_matt has quit IRC
04:34:01 *** User_ has joined #gnucash
04:52:06 *** truelehr has joined #gnucash
05:17:35 *** truelehr has quit IRC
05:51:38 *** User_ has quit IRC
05:54:07 *** warlord has joined #gnucash
06:14:56 *** FH_thecat has joined #gnucash
06:17:03 *** Aussie_matt has joined #gnucash
06:21:36 *** field^Mop has joined #gnucash
07:49:40 *** mydogsnameisrudy has joined #gnucash
07:53:12 *** mydogsnameisrudy has quit IRC
07:54:30 <warlord> .
07:55:42 *** David has quit IRC
07:55:52 *** David has joined #gnucash
08:34:45 *** grunch has joined #gnucash
08:35:26 *** Aussie_matt has quit IRC
08:37:15 *** David has quit IRC
08:37:25 *** David has joined #gnucash
08:53:54 *** grunch has left #gnucash
09:02:09 *** Jimraehl1 has joined #gnucash
09:02:52 *** Jimraehl1 has quit IRC
09:07:22 *** dklann has joined #gnucash
09:08:51 *** sbluhm has quit IRC
09:28:12 *** MatrixTravelerbot[m] has quit IRC
09:28:25 *** PeterScholtens[m] has quit IRC
09:28:31 *** peter-butler[m] has quit IRC
09:28:38 *** jojo[m] has quit IRC
09:32:29 *** MatrixTravelerbot[m] has joined #gnucash
10:00:48 *** bzbarsky has joined #gnucash
10:03:06 *** PeterScholtens[m] has joined #gnucash
10:04:12 *** peter-butler[m] has joined #gnucash
10:08:42 *** o01eg has quit IRC
10:10:22 *** mydogsnameisrudy has joined #gnucash
10:12:30 *** mydogsnameisrudy has quit IRC
10:19:42 *** jojo[m] has joined #gnucash
10:25:20 *** guak has joined #gnucash
10:44:01 *** Pegasus_RPG has joined #gnucash
10:44:21 *** FH_thecat has quit IRC
10:49:18 *** ArtGravity has joined #gnucash
10:49:18 *** ChanServ sets mode: +v ArtGravity
10:50:43 *** jervin has joined #gnucash
11:04:20 *** jcarl43 has joined #gnucash
11:04:20 *** ChanServ sets mode: +v jcarl43
11:06:50 *** Mechtilde has quit IRC
11:26:33 *** Mechtilde has joined #gnucash
11:52:41 *** o01eg has joined #gnucash
12:09:18 *** bzbarsky has quit IRC
12:17:36 *** TownsendHardware has quit IRC
12:27:48 *** Agfarmer18 has joined #gnucash
12:37:37 <fell> gjanssens, about PR 889, I have updated https://wiki.gnucash.org/wiki/Weblate#Workflow.
12:38:36 *** sbluhm has joined #gnucash
12:38:36 *** ChanServ sets mode: +v sbluhm
12:47:53 <gjanssens> fell: thanks
12:49:51 *** sbluhm has quit IRC
13:09:39 *** Agfarmer18 has quit IRC
13:24:51 *** jralls_laptop has quit IRC
13:52:39 *** roxart has quit IRC
14:08:17 *** sbluhm has joined #gnucash
14:08:17 *** ChanServ sets mode: +v sbluhm
14:27:04 *** mydogsnameisrudy has joined #gnucash
14:28:28 *** jralls_laptop has joined #gnucash
14:28:47 *** mydogsnameisrudy has quit IRC
14:31:28 *** jralls_laptop has quit IRC
14:52:11 *** mikee has quit IRC
14:52:30 *** mikee has joined #gnucash
14:52:30 *** ChanServ sets mode: +o mikee
14:53:39 *** Agfarmer18 has joined #gnucash
14:54:40 *** Agfarmer18 has quit IRC
16:01:08 *** jw4 has quit IRC
16:01:37 *** jw4 has joined #gnucash
16:01:37 *** ChanServ sets mode: +v jw4
16:11:07 *** jcarl43 has quit IRC
16:13:26 *** bertbob has quit IRC
16:15:02 *** gjanssens has quit IRC
16:18:23 *** mase has joined #gnucash
16:21:18 <mase> Hi! Is it normal, that Gnucash is somewhat slow when using it with MariaDB? Sometimes it does not respond for over 10 minutes. The db server is in the same lan. I am using Debian.
16:22:14 *** bertbob has joined #gnucash
16:22:14 *** ChanServ sets mode: +v bertbob
16:25:12 <warlord> mase, slow during what operations?
16:25:42 <warlord> It'll be "slow" on open, because it's reading in the whole database into RAM. But once GnuCash is up and running it should be just as fast as anything else.
16:26:00 <warlord> Still, 10 minutes is a VERY long time, unless you have a huge dataset and very little RAM?
16:28:55 *** sparrowhawk has joined #gnucash
16:29:45 *** sparrowhawk has left #gnucash
16:30:18 <mase> Searching is fast, but storing and importing from aqbanking takes long. I see no huge server load and memory usage.
16:31:46 <mase> I have a Kodi (formerly XBMC) database on the same server, which is huge, but works fast.
16:34:21 <warlord> Ah, this is an issue with importing -- it's looking for duplicates, and the algorithm isn't very good/fast. The fact that you're using MySQL behind wouldn't (shouldn't) affect that -- you'd probably see the same performance if you were using XML.
16:38:03 <mase> Reconciliation also takes a long time. XML is fast.
16:40:18 <mase> Importing 20 lines should not take that long
16:41:06 *** sparrohawk has joined #gnucash
16:48:02 <warlord> So if you start with the same data, and import the same data, you find the process much faster with XML than with MySQL?
16:51:40 <mase> Exactly
16:54:03 <mase> Opening the db at program start is pretty fast.
16:57:02 *** sbluhm has quit IRC
16:57:14 <mase> I wanted to get sure, that there are no known issues with libdbd.
16:58:51 <jralls> mase, no known issues, and I don't find much difference in performance between SQLite (which uses libdbd) and XML with a pretty large DB (>50M on SQLite3).
16:59:36 <mase> Thx
17:00:59 <jralls> The main difference that would affect performance is that on SQL GnuCash does an update/insert query every time it commits changes to a transaction, so if there's a lot of latency in setting that up it could hurt performance.
17:01:25 *** truelehr has joined #gnucash
17:03:00 <mase> But not several minutes for20 lines
17:06:52 <mase> Maybe I should save to a xml, delete the db, and save to a new one.
17:07:35 <fell> And the baud rate of your LAN?
17:10:24 <mase> 1 Gbit cable and 300 Mbit wifi.
17:12:58 *** mase has quit IRC
17:13:08 <jralls> mase, You could try that, but it would probably be more productive to run GnuCash with --log gnc.backend.dbi=debug and set up max-verbose logging on your DB server and analyze the two together to see what's causing the delay.
17:13:24 *** mase has joined #gnucash
17:14:20 *** Mechtilde has quit IRC
17:22:08 *** Aussie_matt has joined #gnucash
17:25:47 *** jervin has quit IRC
17:29:43 *** mase has quit IRC
17:34:44 *** jralls_laptop has joined #gnucash
17:37:44 *** jralls_laptop has quit IRC
17:38:53 *** truelehr has quit IRC
17:56:00 *** jervin has joined #gnucash
19:03:35 *** chris has quit IRC
19:16:41 *** mydogsnameisrudy has joined #gnucash
19:17:36 *** mydogsnameisrudy has quit IRC
19:17:39 *** mauritslamers has quit IRC
19:18:15 *** mauritslamers has joined #gnucash
19:18:15 *** ChanServ sets mode: +v mauritslamers
19:19:13 *** miklcct has quit IRC
19:19:17 *** miklcct has joined #gnucash
19:19:17 *** ChanServ sets mode: +v miklcct
19:42:37 *** field^Mop has quit IRC
19:45:49 *** truelehr has joined #gnucash
20:16:39 *** truelehr1 has joined #gnucash
20:18:49 *** truelehr has quit IRC
20:18:49 *** truelehr1 is now known as truelehr
20:48:49 *** truelehr has quit IRC
21:36:18 *** jralls_laptop has joined #gnucash
21:39:18 *** jralls_laptop has quit IRC
21:41:50 *** guak has quit IRC
21:47:07 *** truelehr has joined #gnucash
22:18:50 *** ArtGravity has quit IRC
22:20:07 *** truelehr has quit IRC
22:38:42 *** peter-butler[m] has quit IRC
22:39:13 *** MatrixTravelerbot[m] has quit IRC
23:14:15 *** peter-butler[m] has joined #gnucash
23:18:29 *** jervin has joined #gnucash
23:34:03 *** PowaBanga has quit IRC
23:34:32 *** PowaBanga has joined #gnucash
23:35:51 *** David has quit IRC
23:36:09 *** David has joined #gnucash
23:36:27 *** jcarl43 has joined #gnucash
23:36:27 *** ChanServ sets mode: +v jcarl43
23:37:05 *** jralls_laptop has joined #gnucash
23:40:05 *** jralls_laptop has quit IRC
23:54:06 *** jervin has quit IRC