Search found 188 matches

by w9mdb
24 Jun 2020, 16:29
Forum: Feature suggestions
Topic: Slow queries 2
Replies: 9
Views: 374

Re: Slow queries 2

Also remember to add the index to callsign.

Mike
by w9mdb
24 Jun 2020, 15:51
Forum: User support
Topic: QSL sent = No from JTAlert
Replies: 22
Views: 773

Re: QSL sent = No from JTAlert

That's because nobody knows enough to complain....
I'm a developer so I know what to expect.
by w9mdb
24 Jun 2020, 13:58
Forum: Feature suggestions
Topic: Slow queries 2
Replies: 9
Views: 374

Re: Slow queries 2

I don't see 2+ seconds running through the JSON fields as fast. Maybe not be as easy as a 2nd table...which would require multiple entries per QSL. It would link to the id field in the primary table and contain rows of QSL info for LOTW, EQsl, etc. So 8 rows per QSO....but comparitively short rows. ...
by w9mdb
24 Jun 2020, 13:42
Forum: User support
Topic: QSL sent = No from JTAlert
Replies: 22
Views: 773

Re: QSL sent = No from JTAlert

Well that's completely unintuitive to me...but you're right..that method does work. I thought the Select required would do the same...seems like you could get rid of the Select required and just use the Search and set the default Sent status when the Search confirmation is selected. One less button ...
by w9mdb
24 Jun 2020, 13:28
Forum: Feature suggestions
Topic: Slow queries 2
Replies: 9
Views: 374

Re: Slow queries 2

Hmmm...I wouldn't think 3 more tables would be needed. That might be over normalizing. Essentially it would be the same as the JSON structure but putting that in an indexed table that could be joined. So adding a new one wouldn't require any code changes at all....just a database update. At first bl...
by w9mdb
24 Jun 2020, 12:58
Forum: Feature suggestions
Topic: Slow queries 2
Replies: 9
Views: 374

Re: Slow queries 2

On another note about speed. The queries from JTAlert are like this on every decode (before JTAlert caches the info) select `qsodate` FROM `log` WHERE (`mode` LIKE ''FT8%'') AND (`band` = ''10m'') AND (`callsign`=''W1HS'') ORDER BY `qsoid` DESC; And one like this SELECT dxcc, cont, cqzone, ituzone, ...
by w9mdb
24 Jun 2020, 12:45
Forum: Feature suggestions
Topic: Slow queries 2
Replies: 9
Views: 374

Re: Slow queries 2

The debug log doesn't show the total time...just the query time. I've got over 34,000 QSOs in the log. The actual query I've tested and by itself takes a little over 2.5 seconds evenly split between query and fetch according to MySQL Workbench timing. In order to get any QSL status in this database ...
by w9mdb
24 Jun 2020, 11:52
Forum: User support
Topic: QSL sent = No from JTAlert
Replies: 22
Views: 773

Re: QSL sent = No from JTAlert

My point Terry is that I shouldn't have to change the configuration to select something other than the default and that the default should not be forced when Select Required is clicked. If you can't change it why have a pulldown at all? Isn't that the point of a pulldown to select from multiple valu...
by w9mdb
24 Jun 2020, 03:30
Forum: User support
Topic: QSL sent = No from JTAlert
Replies: 22
Views: 773

Re: QSL sent = No from JTAlert

Oops...let me correct that...still broken... The pull down box on the left side is set to whatever the selection is in Confirmations when you click Select required. I could see setting the default when you pick LOTW as the Search Confirmation...but not when you click Select required. And I'd like to...
by w9mdb
24 Jun 2020, 03:24
Forum: User support
Topic: QSL sent = No from JTAlert
Replies: 22
Views: 773

Re: QSL sent = No from JTAlert

It seems a fresh download and install-over-the-top did fix it.
Seems odd but I'll have my friend try it too.

Thanks Terry,

Mike