[SFDXA] lotw

[The Romagni's]

yeah, I do similar calculation when planning and designing database servers
where high transactions need to be done with in an acceptable threshold,
one of the main issues that lotw has is the way the openqsl db is written
and how the server environment is layout, not enough margin for high loads,
the bottlenecks of IO is pretty much all over the place!

A course for the little info that has been provided to me, I can see where
are the key areas that they need to tackle to get some sort of control!

Steve
W4DTA

On Sat, Dec 15, 2012 at 10:21 AM, Kai Siwiak <k.siwiak at ieee.org> wrote:

> Here are a few interesting observations:
> From http://www.arrl.org/logbook-**queue-status<http://www.arrl.org/logbook-queue-status> we can see that there are 9.1 million QSOs on the bcah log, and that there
> are currently working on uploads from 10 days ago.
>
> But wait! If you check the main page https://p1k.arrl.org/lotwuser/**
> default <https://p1k.arrl.org/lotwuser/default>   you can see that there
> are currently 462,332,121 QSO in the system. Whne I check exactly one hour
> ago there were 462,322,173 QSOs in the system, so they processed 9,948 QSOs
> in one hour. That is a daily rate of 238,752 QSO.
>
> But wait!!!  The current backlog of QSOs is 9.1 million!!!  At a rate of
> 238,752 per day this will take about 38 days to clear!!  So the past
> backlog IS 10 days, but to clear the current backlog of QSOs WILL TAKE 38
> days!!
>
> Just playing with the numbers!!!
>
> 73
> Kai, KE4PT
>
> On 12/15/2012 11:07 AM, The Romagni's wrote:
>
>> Just finally got the email confirmation for my lotw upload, two weeks to
>> process 15 qso's! yeah a major redesign of environment needs to happen!
>>
>> Steve
>> W4DTA
>> ______________________________**______________________________**__
>> South Florida DX Assoc.
>> SFDXA WebSite: http://qsl.net/k4fk
>> SFDXA Repeater 147.33+ 103.5 Tone
>> To Post: mailto:SFDXA at mailman.qth.net
>> Subscribe or UNSubScribe:
>> http://mailman.qth.net/**mailman/listinfo/sfdxa<http://mailman.qth.net/mailman/listinfo/sfdxa>
>> DX Net Wed 7:33 PM Repeater
>>
>> This list hosted by: http://www.qsl.net
>> Please help support this email list: http://www.qsl.net/donate.html
>>
>>
>>  ______________________________**______________________________**__
> South Florida DX Assoc.
> SFDXA WebSite: http://qsl.net/k4fk
> SFDXA Repeater 147.33+ 103.5 Tone
> To Post: mailto:SFDXA at mailman.qth.net
> Subscribe or UNSubScribe:
> http://mailman.qth.net/**mailman/listinfo/sfdxa<http://mailman.qth.net/mailman/listinfo/sfdxa>
> DX Net Wed 7:33 PM Repeater
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>