Search found 6 matches

by sp9wpn
11 Oct 2019, 10:58
Forum: User Support
Topic: cluster is slow
Replies: 8
Views: 256

Re: cluster is slow

If we extract "core callsign", prefix and suffix then copy them to separate columns in the DB, this would allow to return to indexed search. Of course, this is not what they teach you on "how to manage relational database".
by sp9wpn
04 Oct 2019, 22:56
Forum: User Support
Topic: cluster is slow
Replies: 8
Views: 256

Re: cluster is slow

I've run this query through "EXPLAIN QUERY PLAN" and it appears SQLite is ignoring indexes for it - thus making full, slow db scan. The problem lays in the LIKE '%CALL%' part - SQLite will not use indexes for such LIKE queries. No easy solution for Log4OM, as we probably need those double wildcards ...
by sp9wpn
18 Aug 2019, 15:55
Forum: User Support
Topic: KH1/KH7Z shows as Hawaii
Replies: 10
Views: 1406

Re: KH1/KH7Z shows as Hawaii

/LH is a recognised prefix and sometimes suffix for Norway, using it for Lighthouse is not internationally recognised. Actually only prefixes allowed in Norway for CEPT-complaint visitors are LA/ or JW/ , see https://eng.nkom.no/leisure/radio-amateurs/radio-amateurs/information-for-visitors-to-norw...
by sp9wpn
18 Aug 2019, 13:29
Forum: User Support
Topic: KH1/KH7Z shows as Hawaii
Replies: 10
Views: 1406

Re: KH1/KH7Z shows as Hawaii

With Lighthouse event running this weekend, there are plenty of station suffixed "/LH", so Log4OM puts them all in Norway... Could you please disable this "feature"? In my opinion, no software should not promote bad manners (ie. putting country in suffix, not prefix). Many will later recon that coun...
by sp9wpn
11 Jun 2019, 23:02
Forum: Feature suggestions
Topic: thoughts on QSL cards printing/writing
Replies: 0
Views: 234

thoughts on QSL cards printing/writing

Hello, As I promised to Daniele, here are my few thoughts about the present paper QSL card handling features. I don't know how it's going to look like in V2, but maybe these ideas will be useful anyway. 1. First of all, I'd suggest to remove "QSL assistant" and make it a part of "Label printing" (pe...
by sp9wpn
27 May 2019, 22:58
Forum: Error Reports
Topic: sorting by date / time
Replies: 0
Views: 218

sorting by date / time

Hi, I'm just exploring the Log4OM while trying to find the best logging software for myself. After I've imported an ADIF into Log4OM, I've browsed the "Recent QSO" list. It is nicely sorted by QSO time by default. If, however, one clicks "QSO start time" to re-sort the QSOs by time.. they get sorted...