Performance / System Requirements

General discussions V2
Post Reply
AE0S
Novice Class
Posts: 24
Joined: 29 May 2017, 15:43
Contact:
Contact AE0S

Performance / System Requirements

Post by AE0S »

Like others I've been experience less than optimal system performance with Log4OM. For example to open the Edit QSO window takes more than 4 seconds. I only have 7759 QSOs.

I've investigated multiple options to improve performance but none of these caused any difference:
  • Moved from SQLight to MariaDB
  • Inactivating Awards.
  • Disabling "use clublog database" and "use CTY database". (VOACAP is already disabled)
  • Disabling anti virus (Windows Defender).
I've used the same configuration/database on another, more powerful computer, and the performance difference is significant. The Edit QSO windows there takes 1.6s. Unfortunately that computer isn't in my shack so I can't use it for operations with log4om. Below are the details:

My Shack Computer
  • Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2.70 GHz
  • 16.0 GB
  • SSD hard drive
Edit QSO window log:

Code: Select all

19:56:52.374 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:56:52.374 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:56:52.374 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:56:52.374 Debug:         [FwFile][LoadFileAsArray] : LoadFileAsArray: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:56:52.55 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:56:52.55 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:56:52.55 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:56:52.55 Debug:         [FwFile][LoadFileAsArray] : LoadFileAsArray: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:56:52.865 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXX\AppData\Roaming\Log4OM2\propagation.csv
19:56:52.867 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXX\AppData\Roaming\Log4OM2\propagation.csv
19:56:52.869 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\propagation.csv
19:56:52.874 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\propagation.csv
19:56:52.96 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXX\AppData\Roaming\Log4OM2\antpath.csv
19:56:52.96 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXX\AppData\Roaming\Log4OM2\antpath.csv
19:56:52.96 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\antpath.csv
19:56:52.96 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\antpath.csv
19:56:52.975 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXX\AppData\Roaming\Log4OM2\satellites.csv
19:56:52.991 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXX\AppData\Roaming\Log4OM2\satellites.csv
19:56:52.991 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\satellites.csv
19:56:53.007 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\satellites.csv
19:56:53.134 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
19:56:53.134 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
19:56:53.134 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
19:56:53.229 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXX\AppData\Roaming\Log4OM2\contest.csv
19:56:53.251 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXX\AppData\Roaming\Log4OM2\contest.csv
19:56:53.273 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\contest.csv
19:56:53.277 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXX\AppData\Roaming\Log4OM2\contest.csv
19:56:54.452 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Loading Awards items from database for multiple award codes
19:56:54.686 Debug:       * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][225 ms] : Loading Awards items from database for multiple award codes
19:56:56.469 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Awards reference list retrieved from database
19:56:56.476 Debug:       * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][7 ms] : Awards reference list retrieved from database
Performance test:

Code: Select all

Performance test start on 200 calls...

--------------------------------------------------------------------

Worked before on 200 calls
   50ms (503877 CPU cycles)
   240000 calls/minute

Sunrise/sunset check...
   2ms (25079 CPU cycles)
   3000000 calls/minute

External data search check (200 calls)...
0 IS0PMN
1 UB5WAT
2 YO9HT
3 UB5IMZ
4 UA3ATV
5 RO5OW
6 LZ1BY
7 UB5BAZ
8 GW4XLQ
9 HV1CN
10 UR2KAW
11 F9KP
12 UR1RWW
13 PA0XPQ
14 Y24RK
15 I0MPF
16 YU4FDE
17 LZ1KVZ
18 DL1DAQ
19 EC9JM
20 IK6AQU
21 UZ9YWZ
22 UA3AV
23 K3RV
24 K3ZO
25 KM2P
26 KX4S
27 VU2GI
28 CN8LS
29 N8CXX
30 CN8MK
31 UB4EXP
32 OK1AZI
33 UZ3DYD
34 4X4JU
35 IS0TQQ
36 HB9AWS
37 5H3ZR
38 CT1UP
39 TR8SA
40 A4XYQ
41 ET3PG
42 EA6BE
43 I0MWI
44 YU2CCY
45 RD1DWZ
46 JH3JUZ
47 GD4GWQ
48 IK5CXL/IA5
49 ZS3PH
50 8Q7PA
51 UZ1AWW
52 RB4IRO
53 GM4TNJ
54 EI9FT
55 JW0A
56 5X5WR
57 N9AGO
58 RW3PW
59 UD1DGF
60 OD5AS
61 UB4AB
62 CT3AF
63 4X6OM
64 UZ3SWW
65 ZZ5EG
66 JR1PIK
67 SU1ER
68 YC1EHR
69 OK1XC/JT
70 UZ6HXK
71 KH0AC
72 ZC4MR
73 G4UCE
74 LZ1KK
75 ZC4EE
76 EP2DL
77 TA2KA
78 UO5ODA
79 JH9KIF
80 OD5PL
81 C56/EA5AL
82 A4XKB
83 9K2MJ
84 UB5HHI
85 EA1EDB
86 RB5WAM
87 9H1GY
88 RB5UCY
89 OH6NFO
90 SP2BOQ
91 YO3BZF
92 SV5TS
93 UT5RY
94 RB5FBX
95 UO5ONV
96 UB5EJZ
97 FE6GNG
98 SV9ADO
99 GW0AVD
100 DK6SY
101 DF3VD
102 9Y4BA
103 G0DWZ
104 F5RD
105 KY3U
106 OK2BVX
107 LU1DJU
108 CE1GQE
109 7S4FRO
110 YU3PG
111 OE6PND
112 Y47PN
113 LA5CBA
114 EA7FBO
115 SP6KBL
116 PA3CKV
117 HG8QB
118 YO2LAL
119 3C0A
120 UA6LTQ
121 HE9LNU
122 I2QAB/ID9
123 RA6AAS
124 Y21WI
125 OK2TZ
126 PA3CUR
127 EC5CEY
128 ZS6ZG
129 RB5NT
130 YC7KL
131 EA8BML
132 UA4AOM
133 UA6ATQ
134 JH7HJL
135 JE6OFH
136 KA1HCP
137 AB8K
138 HI8FAN
139 KF4YB
140 FM5WD
141 8A8IT
142 A92BE
143 1A0KM
144 SV2TX/SY
145 ZL0AFY
146 EA7DPU
147 JA3BOA
148 JR3BOT
149 VE2LEO
150 N4WW
151 8P21BBS
152 K2KIB
153 PT7WX
154 VK2ENX
155 JA1UMN
156 JF2HGB
157 UZ9YWA
158 JA6ETV
159 JA7WTU
160 JA6YLP
161 C30LEN
162 TU2QQ
163 JA4DOB
164 UY5VA
165 VU4GDG
166 T5GG
167 LU4IAV
168 JL1MWI
169 7P8DP
170 BY1QH
171 4K1A
172 KH2D
173 K4YT/DU8
174 9J2EZ
175 S0RASD
176 HC8DX
177 FR/G/FH4EC
178 S79WS
179 5T5NU
180 JH2QMT
181 3D2RY
182 JA5QJD
183 BY5RA
184 VU2RCK
185 ZS6AMD
186 UZ9LWG
187 RL7FER
188 JA2DSF
189 JA6WFK
190 JA3LA
191 JL1FQJ
192 JA1KRW
193 UB5ILA
194 JR2SFD
195 BV2FA
196 JF1BWA
197 JR1TLC
198 G4POP
199 IQ3ME
   8057ms (80571504 CPU cycles)
   1489 calls/minute

Callsign statistic search...
   31ms (313509 CPU cycles)
   387096 calls/minute

VOACAP test...
   Calculated voacap data for FN21wa Max 0
   Calculated voacap data for IN82eo Max 0
   Calculated voacap data for KH02mt Max 0
   Calculated voacap data for GF17sb Max 0
   Calculated voacap data for FJ49gj Max 0
   Calculated voacap data for CO46xp Max 0
   Calculated voacap data for CO46xp Max 0
   Calculated voacap data for QO94jg Max 0
   Calculated voacap data for ON26kl Max 0
   Calculated voacap data for LP74jq Max 0
   1880ms (18806443 CPU cycles)
   319 calls/minute

External service search...
      IS0PMN Silvano Agus
      UB5WAT
      YO9HT
      UB5IMZ
      UA3ATV
      RO5OW
      LZ1BY Dimitar Buhov
      UB5BAZ Bogdan Leonidovich Oliynyk
      GW4XLQ Ge Jones
      HV1CN Vatican Radio Imd Station
   2444ms (24445996 CPU cycles)
   4909 callsign/minute

OVERALL Country statistic recalculation...
   402 countries checked in 1002ms (10020124 CPU cycles)
   24071 countries/minute

OVERALL Gridsquare statistic recalculation...
   813 items in 2103ms (21037180 CPU cycles)
   23195 gridsquares/minute

OVERALL Worked before statistic recalculation...
   6735 items in 3876ms (38762721 CPU cycles)
   104256 callsign/minute
--------------------------------------------------------------------
Performance test COMPLETE
Reference Computer
  • Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz 3.60 GHz
  • 32GB
  • SSD Hard Drive
Edit QSO window log:

Code: Select all

19:32:44.534 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:32:44.534 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:32:44.534 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:32:44.544 Debug:         [FwFile][LoadFileAsArray] : LoadFileAsArray: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:32:44.604 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:32:44.604 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:32:44.604 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:32:44.614 Debug:         [FwFile][LoadFileAsArray] : LoadFileAsArray: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
19:32:44.714 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\propagation.csv
19:32:44.714 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\propagation.csv
19:32:44.724 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\propagation.csv
19:32:44.724 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\propagation.csv
19:32:44.754 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\antpath.csv
19:32:44.754 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\antpath.csv
19:32:44.764 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\antpath.csv
19:32:44.764 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\antpath.csv
19:32:44.774 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satellites.csv
19:32:44.774 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satellites.csv
19:32:44.781 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satellites.csv
19:32:44.784 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satellites.csv
19:32:44.839 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
19:32:44.844 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
19:32:44.844 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
19:32:44.881 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\contest.csv
19:32:44.884 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\contest.csv
19:32:44.884 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\contest.csv
19:32:44.914 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\contest.csv
19:32:45.354 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Loading Awards items from database for multiple award codes
19:32:45.444 Debug:       * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][90 ms] : Loading Awards items from database for multiple award codes
19:32:46.184 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Awards reference list retrieved from database
19:32:46.194 Debug:       * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][9 ms] : Awards reference list retrieved from database
Performance test:

Code: Select all

Performance test start on 200 calls...

--------------------------------------------------------------------

Worked before on 200 calls
   24ms (240794 CPU cycles)
   500000 calls/minute

Sunrise/sunset check...
   1ms (12575 CPU cycles)
   6000000 calls/minute

External data search check (200 calls)...
0 IS0PMN
1 UB5WAT
2 YO9HT
3 UB5IMZ
4 UA3ATV
5 RO5OW
6 LZ1BY
7 UB5BAZ
8 GW4XLQ
9 HV1CN
10 UR2KAW
11 F9KP
12 UR1RWW
13 PA0XPQ
14 Y24RK
15 I0MPF
16 YU4FDE
17 LZ1KVZ
18 DL1DAQ
19 EC9JM
20 IK6AQU
21 UZ9YWZ
22 UA3AV
23 K3RV
24 K3ZO
25 KM2P
26 KX4S
27 VU2GI
28 CN8LS
29 N8CXX
30 CN8MK
31 UB4EXP
32 OK1AZI
33 UZ3DYD
34 4X4JU
35 IS0TQQ
36 HB9AWS
37 5H3ZR
38 CT1UP
39 TR8SA
40 A4XYQ
41 ET3PG
42 EA6BE
43 I0MWI
44 YU2CCY
45 RD1DWZ
46 JH3JUZ
47 GD4GWQ
48 IK5CXL/IA5
49 ZS3PH
50 8Q7PA
51 UZ1AWW
52 RB4IRO
53 GM4TNJ
54 EI9FT
55 JW0A
56 5X5WR
57 N9AGO
58 RW3PW
59 UD1DGF
60 OD5AS
61 UB4AB
62 CT3AF
63 4X6OM
64 UZ3SWW
65 ZZ5EG
66 JR1PIK
67 SU1ER
68 YC1EHR
69 OK1XC/JT
70 UZ6HXK
71 KH0AC
72 ZC4MR
73 G4UCE
74 LZ1KK
75 ZC4EE
76 EP2DL
77 TA2KA
78 UO5ODA
79 JH9KIF
80 OD5PL
81 C56/EA5AL
82 A4XKB
83 9K2MJ
84 UB5HHI
85 EA1EDB
86 RB5WAM
87 9H1GY
88 RB5UCY
89 OH6NFO
90 SP2BOQ
91 YO3BZF
92 SV5TS
93 UT5RY
94 RB5FBX
95 UO5ONV
96 UB5EJZ
97 FE6GNG
98 SV9ADO
99 GW0AVD
100 DK6SY
101 DF3VD
102 9Y4BA
103 G0DWZ
104 F5RD
105 KY3U
106 OK2BVX
107 LU1DJU
108 CE1GQE
109 7S4FRO
110 YU3PG
111 OE6PND
112 Y47PN
113 LA5CBA
114 EA7FBO
115 SP6KBL
116 PA3CKV
117 HG8QB
118 YO2LAL
119 3C0A
120 UA6LTQ
121 HE9LNU
122 I2QAB/ID9
123 RA6AAS
124 Y21WI
125 OK2TZ
126 PA3CUR
127 EC5CEY
128 ZS6ZG
129 RB5NT
130 YC7KL
131 EA8BML
132 UA4AOM
133 UA6ATQ
134 JH7HJL
135 JE6OFH
136 KA1HCP
137 AB8K
138 HI8FAN
139 KF4YB
140 FM5WD
141 8A8IT
142 A92BE
143 1A0KM
144 SV2TX/SY
145 ZL0AFY
146 EA7DPU
147 JA3BOA
148 JR3BOT
149 VE2LEO
150 N4WW
151 8P21BBS
152 K2KIB
153 PT7WX
154 VK2ENX
155 JA1UMN
156 JF2HGB
157 UZ9YWA
158 JA6ETV
159 JA7WTU
160 JA6YLP
161 C30LEN
162 TU2QQ
163 JA4DOB
164 UY5VA
165 VU4GDG
166 T5GG
167 LU4IAV
168 JL1MWI
169 7P8DP
170 BY1QH
171 4K1A
172 KH2D
173 K4YT/DU8
174 9J2EZ
175 S0RASD
176 HC8DX
177 FR/G/FH4EC
178 S79WS
179 5T5NU
180 JH2QMT
181 3D2RY
182 JA5QJD
183 BY5RA
184 VU2RCK
185 ZS6AMD
186 UZ9LWG
187 RL7FER
188 JA2DSF
189 JA6WFK
190 JA3LA
191 JL1FQJ
192 JA1KRW
193 UB5ILA
194 JR2SFD
195 BV2FA
196 JF1BWA
197 JR1TLC
198 G4POP
199 IQ3ME
   6273ms (62736727 CPU cycles)
   1912 calls/minute

Callsign statistic search...
   16ms (169891 CPU cycles)
   750000 calls/minute

VOACAP test...
   Calculated voacap data for FN21wa Max 0
   Calculated voacap data for IN82eo Max 0
   Calculated voacap data for KH02mt Max 0
   Calculated voacap data for GF17sb Max 0
   Calculated voacap data for FJ49gj Max 0
   Calculated voacap data for CO46xp Max 0
   Calculated voacap data for CO46xp Max 0
   Calculated voacap data for QO94jg Max 0
   Calculated voacap data for ON26kl Max 0
   Calculated voacap data for LP74jq Max 0
   1222ms (12223235 CPU cycles)
   490 calls/minute

External service search...
      IS0PMN Silvano Agus
      UB5WAT
      YO9HT
      UB5IMZ
      UA3ATV
      RO5OW
      LZ1BY Dimitar Buhov
      UB5BAZ Bogdan Leonidovich Oliynyk
      GW4XLQ Ge Jones
      HV1CN Vatican Radio Imd Station
   2022ms (20223951 CPU cycles)
   5934 callsign/minute

OVERALL Country statistic recalculation...
   402 countries checked in 658ms (6581562 CPU cycles)
   36656 countries/minute

OVERALL Gridsquare statistic recalculation...
   813 items in 1263ms (12636158 CPU cycles)
   38622 gridsquares/minute

OVERALL Worked before statistic recalculation...
   6735 items in 2046ms (20464483 CPU cycles)
   197507 callsign/minute
--------------------------------------------------------------------
Performance test COMPLETE
I'm not totally sure why the drop down values for the Edit QSO window are read from files. Most of them are small enough to cache them in memory for future use after first read. But then again I don't have any insights about the framework and implemenation of Log4OM.

The whole point of this post is that there is a certain level of system requirements that Log4OM requires. My shack computer works fine as long as I keep in mind that I can't edit entries on the fly. For high volume QSOs I'd recommend using other apps and then importing the QSOs/ADIF file into Log4OM. Why use Log4OM? Because it's the mothership of logging, where I accumulate the various operations I perform. I use a varied fleet of fighter apps to do specific logging. WSJT-X automatically sends entries via UDP. For NetLogger, I've developed a personal process to print QSL cards / labels and send entries via UDP. POTA activation with Ham2K Portable Logger are imported via ADIF file as are contests that are logged with N3FJP. I do wish I had a more powerful computer and have Log4OM peppier though.

So if you're trying to tweak Log4OM to improve performance like me, you might just have hit the resource limit of your computer. Unfortunately I can't state with certainty that the CPU is the main bottle neck or if the 32GB ram (and increased bus speeds) also contributed to it.
Top
User avatar
G4POP
Log4OM Alpha Team
Posts: 11570
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Performance / System Requirements

Post by G4POP »

Something wrong somewhere because I dont have any issues with my i3 laptop or my Lynx windows tablet!

The PC spec that you have should run like a train, have you tried without anti virus and firewalls running

Where is the Maria database stored - I have over 80K QSO's on an i3 with sqlite database and no problem
73 Terry G4POP
Top
AE0S
Novice Class
Posts: 24
Joined: 29 May 2017, 15:43
Contact:
Contact AE0S

Re: Performance / System Requirements

Post by AE0S »

Terry, it runs like an American freight train, reliable and solid, just not fast. :)

I did try it without anti virus. MariaDB is stored and run on the same computer.

I'd be curious to see your debug log when you open the Edit QSO window to compare to mine.

Claus
Top
User avatar
G4POP
Log4OM Alpha Team
Posts: 11570
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Performance / System Requirements

Post by G4POP »

Claus
Here is my logfile in trace mode while opening and then save and apply to a QSO edit window from the recent QSO list

Total time from opening the edid window to closing and saving is aprox 3 seconds which is about as fast as I can click the mouse.

This on an i3 with 256 SSD and 8gb Ram - Log4OM 2.35.1.0


2025-03-05 11:30:01.0720 TRACE: [FwHam][ExtractCallsign] : Extracting callsign from G4POP
2025-03-05 11:30:01.0720 TRACE: [FwHam][ExtractCallsign] : G4POP -> G4POP with prefix
2025-03-05 11:30:01.0730 TRACE: [FwHam][ExtractCallsign] : Extracting callsign from OZ1W
2025-03-05 11:30:01.0730 TRACE: [FwHam][ExtractCallsign] : OZ1W -> OZ1W with prefix
2025-03-05 11:30:01.0730 TRACE: [FwHam][ExtractCallsign] : Extracting callsign from G4POP
2025-03-05 11:30:01.0740 TRACE: [FwHam][ExtractCallsign] : G4POP -> G4POP with prefix
2025-03-05 11:30:01.0740 TRACE: [FwHam][ExtractCallsign] : Extracting callsign from OZ1W
2025-03-05 11:30:01.0740 TRACE: [FwHam][ExtractCallsign] : OZ1W -> OZ1W with prefix
2025-03-05 11:30:01.0750 TRACE: [FwHam][ExtractCallsign] : Extracting callsign from G4POP
2025-03-05 11:30:01.0750 TRACE: [FwHam][ExtractCallsign] : G4POP -> G4POP with prefix
2025-03-05 11:30:01.0755 TRACE: [FwHam][ExtractCallsign] : Extracting callsign from OZ1W
2025-03-05 11:30:01.0755 TRACE: [FwHam][ExtractCallsign] : OZ1W -> OZ1W with prefix
2025-03-05 11:30:01.3952 DEBUG: * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][326 ms] : Awards reference list retrieved from database
2025-03-05 11:30:01.3952 DEBUG: * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][326 ms] : Awards reference list retrieved from database
2025-03-05 11:30:01.4731 DEBUG: [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Awards reference list retrieved from database
2025-03-05 11:30:02.1592 TRACE: [dje_z7RVM5NK43SU5374TE272R_ejd][MoveNext] : Executing planned scheduler...
2025-03-05 11:30:02.1600 TRACE: [LogWriter][DumpProcess] : ## DUMP MODULES ##
2025-03-05 11:30:02.1600 TRACE: [LogWriter][DumpProcess] : ## DUMP ##SearchCallsign Countries 1
2025-03-05 11:30:02.1610 TRACE: [LogWriter][DumpProcess] : ## DUMP ##MoveNext dje_zJB3LYQHRGLJKZBQU2LZE3_ejd 1
2025-03-05 11:30:02.1610 TRACE: [LogWriter][DumpProcess] : ## DUMP ##MoveNext dje_zDZG8A6KJEDEQ4MUEFJS43_ejd 1
2025-03-05 11:30:02.1610 TRACE: [dje_z7RVM5NK43SU5374TE272R_ejd][MoveNext] : Planned scheduler executed...
2025-03-05 11:30:03.9535 INFO: * [dje_zQBJSQW9B7NJGDJW8WMAR9LMQ6HWA_ejd] [AWARDPARSER] : Award Management - Parse qso started on OZ1W|09/02/2025 11:06:21|40m|LSB
2025-03-05 11:30:03.9545 DEBUG: * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][2481 ms] : Loading Awards items from database for multiple award codes
2025-03-05 11:30:04.1873 TRACE: [FwHam][ExtractCallsign] : Extracting callsign from W6SRI
2025-03-05 11:30:04.1883 TRACE: [FwHam][ExtractCallsign] : W6SRI -> W6SRI with prefix
2025-03-05 11:30:04.2438 DEBUG: [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Awards reference list retrieved from database
2025-03-05 11:30:04.2438 INFO: * [dje_zQBJSQW9B7NJGDJW8WMAR9LMQ6HWA_ejd] [AWARDPARSER - 290 ms] : Award Management - Parse qso terminated on OZ1W|09/02/2025 11:06:21|40m|LSB
2025-03-05 11:30:04.2438 TRACE: [DbSqlite][dje_zSXDZDGP4ABEMN3A_ejd] : UPDATE log SET Callsign = @Callsign, Band = @Band, Mode = @Mode, QsoDate = @QsoDate, Address = @Address, StationCallsign = @StationCallsign, DXCC = @DXCC, ArrlSect = @ArrlSect, QsoComplete = @QsoComplete, Age = @Age, AIndex = @AIndex, AntAz = @AntAz, AntEl = @AntEl, AntPath = @AntPath, Antenna = @Antenna, ArrlCheck = @ArrlCheck, BandRX = @BandRX, CallsignUrl = @CallsignUrl, Class = @Class, Cnty = @Cnty, Comment = @Comment, Cont = @Cont, ContactAssociations = @ContactAssociations, ContactedOp = @ContactedOp, ContestId = @ContestId, Country = @Country, CQZone = @CQZone, Distance = @Distance, EqCall = @EqCall, EMail = @EMail, ForceInit = @ForceInit, Freq = @Freq, FreqRx = @FreqRx, GridSquare = @GridSquare, ITUZone = @ITUZone, KIndex = @KIndex, Lat = @Lat, Lon = @Lon, MaxBursts = @MaxBursts, MSShower = @MSShower, MyAssociations = @MyAssociations, MyDxcc = @MyDxcc, MyLat = @MyLat, MyLon = @MyLon, MyCity = @MyCity, MyCnty = @MyCnty, MyCountry = @MyCountry, MyCQZone = @MyCQZone, MyGridSquare = @MyGridSquare, MyITUZone = @MyITUZone, MyName = @MyName, MyPostalCode = @MyPostalCode, MyStreet = @MyStreet, MyRig = @MyRig, MySig = @MySig, MySigInfo = @MySigInfo, MyState = @MyState, Name = @Name, Notes = @Notes, NrBursts = @NrBursts, NrPings = @NrPings, Pfx = @Pfx, Operator = @Operator, OwnerCallsign = @OwnerCallsign, Precedence = @Precedence, PropMode = @PropMode, ProgramId = @ProgramId, ProgramVersion = @ProgramVersion, QslMsg = @QslMsg, QslVia = @QslVia, QsoEndDate = @QsoEndDate, QsoRandom = @QsoRandom, Qth = @Qth, RxPwr = @RxPwr, SFI = @SFI, Sig = @Sig, SigInfo = @SigInfo, RSTRcvd = @RSTRcvd, RSTSent = @RSTSent, SatelliteQSO = @SatelliteQSO, SatMode = @SatMode, SatName = @SatName, SRX = @SRX, SRXString = @SRXString, State = @State, STX = @STX, STXString = @STXString, SWL = @SWL, TxPwr = @TxPwr, QsoConfirmations = @QsoConfirmations, ContactReferences = @ContactReferences, MyReferences = @MyReferences WHERE QsoId = @QsoId
2025-03-05 11:30:04.2453 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Database parameters:
2025-03-05 11:30:04.2453 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : QsoId -> 20250209110636494
2025-03-05 11:30:04.2453 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Callsign -> OZ1W
2025-03-05 11:30:04.2453 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Band -> 40m
2025-03-05 11:30:04.2464 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Mode -> LSB
2025-03-05 11:30:04.2464 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : QsoDate -> 2025-02-09 11:06:21Z
2025-03-05 11:30:04.2464 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Address -> Kildedal, Nr. Vedby Kirkevej 15
Nr. Alslev, Falster Island
4840
Denmark
2025-03-05 11:30:04.2464 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : StationCallsign -> G4POP
2025-03-05 11:30:04.2474 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : DXCC -> 221
2025-03-05 11:30:04.2474 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ArrlSect ->
2025-03-05 11:30:04.2474 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : QsoComplete -> True
2025-03-05 11:30:04.2474 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Age -> 0
2025-03-05 11:30:04.2484 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : AIndex -> 11
2025-03-05 11:30:04.2484 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : AntAz -> 59
2025-03-05 11:30:04.2484 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : AntEl -> 0
2025-03-05 11:30:04.2484 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : AntPath ->
2025-03-05 11:30:04.2494 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Antenna ->
2025-03-05 11:30:04.2494 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ArrlCheck ->
2025-03-05 11:30:04.2494 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : BandRX ->
2025-03-05 11:30:04.2494 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : CallsignUrl ->
2025-03-05 11:30:04.2504 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Class ->
2025-03-05 11:30:04.2504 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Cnty ->
2025-03-05 11:30:04.2504 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Comment ->
2025-03-05 11:30:04.2504 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Cont -> EU
2025-03-05 11:30:04.2514 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ContactedOp ->
2025-03-05 11:30:04.2514 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ContestId ->
2025-03-05 11:30:04.2514 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Country -> Denmark
2025-03-05 11:30:04.2514 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : CQZone -> 14
2025-03-05 11:30:04.2524 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Distance -> 815.69
2025-03-05 11:30:04.2524 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : EqCall ->
2025-03-05 11:30:04.2524 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : EMail ->
2025-03-05 11:30:04.2524 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ForceInit -> 0
2025-03-05 11:30:04.2534 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Freq -> 7100.000
2025-03-05 11:30:04.2534 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : FreqRx -> 0.000
2025-03-05 11:30:04.2534 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : GridSquare -> JO54vv
2025-03-05 11:30:04.2534 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ITUZone -> 18
2025-03-05 11:30:04.2544 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : KIndex -> 2
2025-03-05 11:30:04.2544 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Lat -> 54.9092
2025-03-05 11:30:04.2544 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Lon -> 11.82808
2025-03-05 11:30:04.2544 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MaxBursts -> 0
2025-03-05 11:30:04.2554 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MSShower ->
2025-03-05 11:30:04.2554 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyDxcc -> 223
2025-03-05 11:30:04.2554 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyLat -> 51.64583
2025-03-05 11:30:04.2554 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyLon -> 0.79167
2025-03-05 11:30:04.2554 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyCity ->
2025-03-05 11:30:04.2566 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyCnty ->
2025-03-05 11:30:04.2566 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyCountry -> England
2025-03-05 11:30:04.2566 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyCQZone -> 14
2025-03-05 11:30:04.2566 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyGridSquare -> JO01jp
2025-03-05 11:30:04.2576 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyITUZone -> 27
2025-03-05 11:30:04.2576 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyName -> Terry
2025-03-05 11:30:04.2576 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyPostalCode ->
2025-03-05 11:30:04.2576 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyStreet ->
2025-03-05 11:30:04.2586 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyRig ->
2025-03-05 11:30:04.2586 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MySig ->
2025-03-05 11:30:04.2586 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MySigInfo ->
2025-03-05 11:30:04.2596 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyState ->
2025-03-05 11:30:04.2596 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Name -> Graham
2025-03-05 11:30:04.2596 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Notes ->
2025-03-05 11:30:04.2596 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : NrBursts -> 0
2025-03-05 11:30:04.2606 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : NrPings -> 0
2025-03-05 11:30:04.2606 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Pfx -> OZ1
2025-03-05 11:30:04.2606 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Operator -> G4POP
2025-03-05 11:30:04.2606 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : OwnerCallsign -> G4POP
2025-03-05 11:30:04.2606 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Precedence ->
2025-03-05 11:30:04.2616 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : PropMode ->
2025-03-05 11:30:04.2616 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ProgramId -> LOG4OM2
2025-03-05 11:30:04.2616 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ProgramVersion -> 2.34.0.13
2025-03-05 11:30:04.2616 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : QslMsg ->
2025-03-05 11:30:04.2626 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : QslVia ->
2025-03-05 11:30:04.2626 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : QsoEndDate -> 2025-02-09 11:06:35Z
2025-03-05 11:30:04.2626 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : QsoRandom -> True
2025-03-05 11:30:04.2626 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Qth -> Nr. Alslev, Falster Island
2025-03-05 11:30:04.2636 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : RxPwr -> 0
2025-03-05 11:30:04.2636 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : SFI -> 173
2025-03-05 11:30:04.2636 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : Sig ->
2025-03-05 11:30:04.2636 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : SigInfo ->
2025-03-05 11:30:04.2636 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : RSTRcvd -> 59
2025-03-05 11:30:04.2636 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : RSTSent -> 59
2025-03-05 11:30:04.2651 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : SatelliteQSO -> False
2025-03-05 11:30:04.2651 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : SatMode ->
2025-03-05 11:30:04.2651 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : SatName ->
2025-03-05 11:30:04.2651 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : SRX -> 0
2025-03-05 11:30:04.2661 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : SRXString ->
2025-03-05 11:30:04.2661 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : State ->
2025-03-05 11:30:04.2661 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : STX -> 0
2025-03-05 11:30:04.2661 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : STXString ->
2025-03-05 11:30:04.2671 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : SWL -> False
2025-03-05 11:30:04.2671 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : TxPwr -> 8
2025-03-05 11:30:04.2671 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : QsoConfirmations -> [{"CT":"QSL","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"EQSL","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"LOTW","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"QRZCOM","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"HAMQTH","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"HRDLOG","S":"No","R":"No","SV":"Electronic","RV":"Electronic"},{"CT":"CLUBLOG","S":"No","R":"No","SV":"Electronic","RV":"Electronic"}]
2025-03-05 11:30:04.2671 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ContactReferences -> [{"AC":"WPX","R":"OZ1","G":"221","SUB":[],"GRA":[]},{"AC":"WITUZ","R":"18","SUB":[],"GRA":[]},{"AC":"WAZ","R":"14","SUB":[],"GRA":[]},{"AC":"WAC","R":"EU","SUB":[],"GRA":[]},{"AC":"VUCC","R":"JO54","G":"221","SUB":[],"GRA":[]},{"AC":"DXCC","R":"221","G":"EU","SUB":[],"GRA":[]}]
2025-03-05 11:30:04.2681 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyReferences ->
2025-03-05 11:30:04.2681 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : ContactAssociations ->
2025-03-05 11:30:04.2681 TRACE: [DbSqlite][dje_z97K2DEC3A278UY2_ejd] : MyAssociations -> FISTS@2289
2025-03-05 11:30:04.3444 TRACE: [DbSqlite][dje_zSXDZDGP4ABEMN3A_ejd] : [SQLITE] InsertUpdateDatabase Command issued Callsign: OZ1W Date: 09/02/2025 11:06:21 Band: 40m Mode: LSB
2025-03-05 11:30:04.3454 INFO: [dje_zS6CA2SCHYQRAN63E7B65S_ejd] : QSO Callsign: OZ1W Date: 09/02/2025 11:06:21 Band: 40m Mode: LSB Saved
2025-03-05 11:30:04.3454 TRACE: [WindowPositions][AddLocation] : [WIN POSITION] Updating form location for dje_zKYSYJY8SE2QVL6FKJWX8RSDTSY8B8FRHFX_ejd QsoEditForm: L4ONG.Common.WindowPosition
Attachments
Log4OM_log_20250305100830.txt
(5.35 KiB) Downloaded 39 times
73 Terry G4POP
Top
AE0S
Novice Class
Posts: 24
Joined: 29 May 2017, 15:43
Contact:
Contact AE0S

Re: Performance / System Requirements

Post by AE0S »

Thanks Terry, your attached log was exactly what I was looking for to compare with my tests. You only needed 1.8s vs my 4.1s so there is definitely something odd with my computer. I reinstalled Log4OM, ran it in Windows Safe Mode but no improvements. It's using that much time.

I did find another computer with similar specs to test out my database and got 2.2s.
Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz 2.70 GHz
16.0 GB
SSD hard drive

Code: Select all

00:46:13.606 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\clublist.txt
00:46:13.622 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\clublist.txt
00:46:13.622 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\clublist.txt
00:46:13.622 Debug:         [FwFile][LoadFileAsArray] : LoadFileAsArray: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\clublist.txt
00:46:13.717 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\clublist.txt
00:46:13.723 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\clublist.txt
00:46:13.727 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\clublist.txt
00:46:13.731 Debug:         [FwFile][LoadFileAsArray] : LoadFileAsArray: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\clublist.txt
00:46:13.876 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\propagation.csv
00:46:13.876 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\propagation.csv
00:46:13.892 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\propagation.csv
00:46:13.892 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\propagation.csv
00:46:13.923 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\antpath.csv
00:46:13.939 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\antpath.csv
00:46:13.939 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\antpath.csv
00:46:13.939 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\antpath.csv
00:46:13.962 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\satellites.csv
00:46:13.962 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\satellites.csv
00:46:13.973 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\satellites.csv
00:46:13.977 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\satellites.csv
00:46:14.045 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\satmodelist.txt
00:46:14.05 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\satmodelist.txt
00:46:14.057 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\satmodelist.txt
00:46:14.082 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\contest.csv
00:46:14.106 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\contest.csv
00:46:14.114 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\contest.csv
00:46:14.118 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\FamilyNiesen\AppData\Roaming\Log4OM2\contest.csv
00:46:14.701 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Loading Awards items from database for multiple award codes
00:46:14.701 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Loading Awards items from database for multiple award codes
00:46:14.78 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Loading Awards items from database for multiple award codes
00:46:15.852 Debug:       * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][1069 ms] : Awards reference list retrieved from database
00:46:15.852 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Awards reference list retrieved from database
00:46:15.856 Debug:       * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][3 ms] : Awards reference list retrieved from database
I'm kind of clueless what else to try besides wiping the hard drive and reinstalling everything fresh. Having a peppier Log4OM would be nice.

73,
Claus
Top
User avatar
G4POP
Log4OM Alpha Team
Posts: 11570
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Performance / System Requirements

Post by G4POP »

Did you dissable Voacap?
73 Terry G4POP
Top
AE0S
Novice Class
Posts: 24
Joined: 29 May 2017, 15:43
Contact:
Contact AE0S

Re: Performance / System Requirements

Post by AE0S »

Voacap was disabled.

I've wiped and reinstalled Windows 10 and everything again. Now the edit window opens in 1.5 seconds. Much better.

Code: Select all

04:28:39.209 Info:          [LogWriter] : ### LOG LEVEL CHANGED FROM Info TO Debug
04:28:45.173 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
04:28:45.173 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
04:28:45.173 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
04:28:45.173 Debug:         [FwFile][LoadFileAsArray] : LoadFileAsArray: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
04:28:45.226 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
04:28:45.226 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
04:28:45.226 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
04:28:45.242 Debug:         [FwFile][LoadFileAsArray] : LoadFileAsArray: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\clublist.txt
04:28:45.327 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\propagation.csv
04:28:45.342 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\propagation.csv
04:28:45.342 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\propagation.csv
04:28:45.342 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\propagation.csv
04:28:45.358 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\antpath.csv
04:28:45.358 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\antpath.csv
04:28:45.358 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\antpath.csv
04:28:45.358 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\antpath.csv
04:28:45.374 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satellites.csv
04:28:45.374 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satellites.csv
04:28:45.374 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satellites.csv
04:28:45.374 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satellites.csv
04:28:45.405 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
04:28:45.405 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
04:28:45.405 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\satmodelist.txt
04:28:45.427 Debug:         [FwFile][ComposeFilename] :    ComposeUserFilename: Returning file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\contest.csv
04:28:45.427 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Begin load text file C:\Users\XXXXXX\AppData\Roaming\Log4OM2\contest.csv
04:28:45.427 Debug:         [FwFile][LoadFileAsList] : LoadFileAsList: Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\contest.csv
04:28:45.427 Debug:         [FwFile][LoadFileAsDictionaryStr] : Text file load completed C:\Users\XXXXXX\AppData\Roaming\Log4OM2\contest.csv
04:28:45.759 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Loading Awards items from database for multiple award codes
04:28:45.828 Debug:       * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][69 ms] : Loading Awards items from database for multiple award codes
04:28:45.961 Debug:         [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext] : Awards reference list retrieved from database
04:28:46.657 Debug:       * [dje_zJB3LYQHRGLJKZBQU2LZE3_ejd][MoveNext][696 ms] : Awards reference list retrieved from database
Top
WA2SQQ
Old Man
Posts: 344
Joined: 16 Feb 2015, 20:13
Location: New Jersey US

Re: Performance / System Requirements

Post by WA2SQQ »

While attempting to edit a QSO, open the "processes" window and check which other applications that are running might be using an abnormally high CPU resource. I run my install with an i5 and have absolutely no lag issues.
Top
VE3EY
Novice Class
Posts: 13
Joined: 14 Feb 2022, 18:21

Re: Performance / System Requirements

Post by VE3EY »

My log has about 160K QSOs. In the past I also tried various combinations of databases (local and remote) but nothing seemed to help, however one of the recent LOG4OM updates included an updated SQL driver and it made a significant positive impact. Entering a single QSO into the log would take anywhere between 3-6 seconds before that upgrade. Now it is OK but not instant.

My biggest gripe is the Award status. Selecting a "DXCC award" option before doing anything else takes about 2 minutes before any data is returned. I don't know how to improve this part.

Otherwise, I am very happy with overall features and functions of the logger.

Nick, VE3EY
Top
F4WBL
Novice Class
Posts: 20
Joined: 25 Mar 2020, 12:39

Re: Performance / System Requirements

Post by F4WBL »

Subject: Persistent Performance Issues with Log4OM

Hello,

Unfortunately, this is not a new topic:
viewtopic.php?t=7926&hilit=Slow+Slowdown&start=20

We’ve all followed the suggested tips, but Log4OM remains slow — regardless of the PC configuration (whether it’s a fast or slow machine).

Even putting contest-related issues aside, simply editing a QSO takes a lot of time. Just logging a few contacts noticeably slows the program down.

I tested it on Windows 11 with a 15,000 QSO database (on a friend’s PC), and it runs very fast — for now.
Reading through the forum, I’ve noticed some users mentioned that reinstalling Windows 10 helped temporarily.
Others say installing a newer version of Log4OM improves performance — also temporarily.

So I’m wondering…
Could this be linked to Windows 10 itself?

I love Log4OM and really hope we can identify what’s causing the slowdown.

Best regards,

XV9R /F4WBL emmanuel
Top
Post Reply

Return to “General discussions”