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. ...

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 ...

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...

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, ...

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 ...

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...

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...

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

The left side.
Click the left side pulldown to a non-default and click the "Sent" box. Then click "Select required" -- the box turns back to the default so the pulldown is useless.

Mike

If you're not going to fix the pulldown in the QSL manager so we can select a status other than the default for LOTW you should at least make the box read only since it apparently has no effect. Then all the users would have to do is try and figure out how to fix their problem. Or do you think it sh...