A way long Refreshing on V2.13

f5mxh
Novice Class
Posts: 13
Joined: 22 Mar 2017, 18:55

Re: A way long Refreshing on V2.13

Post by f5mxh »

I tried few experience:
- Fresh installation on a computer without any previous version,
- Portable version,
- And the computer where I made previous tests.

I the 3 cases I have the same problem: the unique common parameter is the SQL database, with is located on a remote server...

...
f5mxh
Novice Class
Posts: 13
Joined: 22 Mar 2017, 18:55

Re: A way long Refreshing on V2.13

Post by f5mxh »

Hello Terry,
That is the problem! With a sqlite database, refresh" takes less than 1 second.

The difference is between 2.13 and 2.12 on the access of the sql database..

73 de f5mxh Thierry.
PA2TA
Novice Class
Posts: 4
Joined: 06 May 2021, 18:02

Re: A way long Refreshing on V2.13

Post by PA2TA »

Hello,

I'm running Log4OM2 from 3 different locations/PC's on a remote MySQL server and after updating to 2.13 a refresh would take up to 45 seconds, whereas in 2.12 this only takes a few seconds. This problem occurs on all 3 locations.
The database contains about 37k records, one PC is a quad core i7 running Windows 7, the second is a virtual machine running Windows 10 and the third machine is a laptop with a quad core i7, also running Windows 10.

Using a local SQLite DB (with the same records), 2.13 performs very well, a refresh will only take 1 or 2 seconds.
I also tried to create a new MySQL database using version 2.13 to see if that would make a difference, but it doesn't.
For now i reverted back to 2.12.

As f5mxh already stated, it looks like the common denominator is MySQL on a remote server.

73 PA2TA
F6FLU
Old Man
Posts: 432
Joined: 03 Aug 2015, 15:33
Location: Near Paris
Contact:

Re: A way long Refreshing on V2.13

Post by F6FLU »

Hello
I use a laptop PC with an i5 / 8Gb and SSD

My Database (SQLite) is on this SSD no via the network

well if I want to modify a QSO, I double-click on the QSO in question, the display of the "Edit QSO" window is only completely displayed after 13 seconds.

As I have hundreds of QSOs to modify (to add RDA) it is practically unusable here and so I deleted the display of VOACAP in the parameters which still saves a few seconds ...
Dan - F6FLU
Log4OM V2.31.0.0 - Windows 11 - i9-11900K - SSD 512Go - 32 Go
FTdx101D - Hexbeam - Wired dipole 40-30M
https://F6FLU.com
PA2TA
Novice Class
Posts: 4
Joined: 06 May 2021, 18:02

Re: A way long Refreshing on V2.13

Post by PA2TA »

F6FLU wrote: 12 May 2021, 13:48 Hello
I use a laptop PC with an i5 / 8Gb and SSD

My Database (SQLite) is on this SSD no via the network

well if I want to modify a QSO, I double-click on the QSO in question, the display of the "Edit QSO" window is only completely displayed after 13 seconds.

As I have hundreds of QSOs to modify (to add RDA) it is practically unusable here and so I deleted the display of VOACAP in the parameters which still saves a few seconds ...
Hello Dan,

This doesn't seem to be the same problem because both f5mxh and me have no performance problem with a local SQLite database.

I'm not sure what you mean by "add RDA", but if you have to update a lot of records with the same data you could have a look at bulk editing or bulk updating, just search the help file for the word "bulk".

73 PA2TA
HB9ETR
Advanced Class
Posts: 93
Joined: 11 Sep 2013, 18:48
Location: Switzerland

Re: A way long Refreshing on V2.13

Post by HB9ETR »

F6FLU wrote: 12 May 2021, 13:48 Hello
I use a laptop PC with an i5 / 8Gb and SSD

My Database (SQLite) is on this SSD no via the network

well if I want to modify a QSO, I double-click on the QSO in question, the display of the "Edit QSO" window is only completely displayed after 13 seconds.

As I have hundreds of QSOs to modify (to add RDA) it is practically unusable here and so I deleted the display of VOACAP in the parameters which still saves a few seconds ...
ditto on the modify issue (not as long...but progressively gets worse the more I edit)
Rob
HB9ETR / G0IFL

K3/Win4K3Suite/OnmiRig/L4OM v2.31.0.0
Win10 i7-6700
User avatar
f4gwm
Advanced Class
Posts: 33
Joined: 18 Jan 2020, 17:07

Re: A way long Refreshing on V2.13

Post by f4gwm »

Hello,

I have the same problem as discribe since i have the 2.13 version of the software.
The refreshing is quite long and before with the 2.12 version i have not the same problem i am also using the sqlite database and no problem with performance quite the same of the other user.
It is a little bite boring when you make many contact just behind the other because it is take time to refresh and add the new contact.

Someone find a solution for this ?

many thanks

cedric
F4GWM
CEDRIC
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: A way long Refreshing on V2.13

Post by IW3HMH »

f4gwm wrote: 15 May 2021, 07:32 I have the same problem as discribe since i have the 2.13 version of the software.
cedric
Are you using MySQL too?
Daniele Pistollato - IW3HMH
User avatar
PA0FVH
Novice Class
Posts: 8
Joined: 22 Jan 2017, 19:47
Location: Veenendaal, Netherlands
Contact:

Re: A way long Refreshing on V2.13

Post by PA0FVH »

I am on MySQL (MariaDB v10.5) and I am experiencing the same issue. If I switch to QSLite the refreshes are fast.

73 Fred
f5mxh
Novice Class
Posts: 13
Joined: 22 Mar 2017, 18:55

Re: A way long Refreshing on V2.13

Post by f5mxh »

Hello,
No news at the moment, but I hope this will be correct in the next version
73, de F5MXH
Post Reply