Author Topic: Hey, you software and website designer guys here  (Read 13122 times)

0 Members and 1 Guest are viewing this topic.

Offline gryphon

  • Administrator
  • *****
  • Posts: 4037
  • First Name (Displayed): Dan
Hey, you software and website designer guys here
« on: March 20, 2014, 05:28:33 PM »
When the ATF created a digital system for submitting NFA paperwork, Form 4 approvals were cut from 6-10 months down to 60 days or less. But then the system started becoming unstable and nearly impossible to use at times.  Like healthcare.gov unstable.  The ATF’s E-Forms division is blaming one store that is batch filing forms (an option the ATF makes available).  The store is calling shenanigans on that claim, saying they only batch upload their forms between the hours of 4 and 5 AM, leaving the system open during the day for everyone else.

Opinions?

http://www.thetruthaboutguns.com/2014/03/foghorn/disgruntled-ffls-claim-austins-silencer-shop-single-handedly-crashing-atfs-e-forms-system/

Offline TheQ

  • Website Content Manager
  • MOC Lifetime Member
  • *
  • Posts: 4263
    • Michigan Open Carry, Inc.
  • First Name (Displayed): Phillip
Hey, you software and website designer guys here
« Reply #1 on: March 20, 2014, 05:35:37 PM »
How many forms are they submitting? If the forms are valid business, it sounds like the ATF did not size their system properly.
I Am Not A Lawyer (nor a gunsmith).

Offline TheQ

  • Website Content Manager
  • MOC Lifetime Member
  • *
  • Posts: 4263
    • Michigan Open Carry, Inc.
  • First Name (Displayed): Phillip
Hey, you software and website designer guys here
« Reply #2 on: March 20, 2014, 05:41:06 PM »
... Or maybe their developers write code that resembles dog $#|t.

I've seen the system administrators of various systems blamed for systems that perform poorly when the code sucks.
I Am Not A Lawyer (nor a gunsmith).

Offline SD40VE

  • SE Region Posse
  • Posts: 996
  • New Haven, Macomb County
  • First Name (Displayed): Bradley
Re: Hey, you software and website designer guys here
« Reply #3 on: March 20, 2014, 05:54:30 PM »
thats what i was thinking, the coding.

they are also using a batch file system to upload them, they could be causing the issue with their software that does the batch upload. without seeing hands on and being able to trouble shoot and exclude things that could cause the issue it is pure speculation at this point

Offline gryphon

  • Administrator
  • *****
  • Posts: 4037
  • First Name (Displayed): Dan
Re: Hey, you software and website designer guys here
« Reply #4 on: March 20, 2014, 06:56:58 PM »
... Or maybe their developers write code that resembles dog $#|t.

I'll take sucky code for $200, Alex.

Offline m.marino

  • Posts: 113
  • First Name (Displayed): Michael
Re: Hey, you software and website designer guys here
« Reply #5 on: March 21, 2014, 05:11:19 AM »
I'll take sucky code for $200, Alex.

 :yeahthat:

Having done a bit of coding on computers and a lot of g-code work, as well as having family that do that as part of their job. I am with sucky code and bad administration of said program (IF you know the fault is there and don't fix it then you are just as much to blame as the idiot who sold you bad code). Given other factors one can see in the current administration that type of lazy is well within possible. -Michael
Tuebor Libertatus

Offline bigt8261

  • MOC President
  • MOC Board Member
  • ******
  • Posts: 1482
    • Michigan Open Carry, Inc
  • First Name (Displayed): Tom
Re: Hey, you software and website designer guys here
« Reply #6 on: March 21, 2014, 08:08:27 AM »
It's a customers fault for properly using an available feature?  :|>  :BS: :BS: :BS:

+1 it's the code.

Offline part deux

  • MOC Member
  • *
  • Posts: 683
Re: Hey, you software and website designer guys here
« Reply #7 on: March 21, 2014, 08:54:47 AM »
Anybody consider the possibility the ATF just might have intentionally make it difficult to file?

Offline gryphon

  • Administrator
  • *****
  • Posts: 4037
  • First Name (Displayed): Dan
Re: Hey, you software and website designer guys here
« Reply #8 on: March 21, 2014, 09:06:23 AM »
I have a real issue with reporters who fail to ask the relevant and proper questions, whether it be mlive here in Michigan or whoever talked to the ATF here in this situation.  If someone uploads their forms to the E-File system at 4:00 AM, how does that make the system all but unusable during regular business hours of 9:00 AM - 5:00 PM?

Offline bigt8261

  • MOC President
  • MOC Board Member
  • ******
  • Posts: 1482
    • Michigan Open Carry, Inc
  • First Name (Displayed): Tom
Re: Hey, you software and website designer guys here
« Reply #9 on: March 21, 2014, 09:14:22 AM »
If someone uses an available feature during the hours of 9-5, how does that make the rest of the application unusable at all?

That's like saying you can't hit the break and turn the steering wheel at the same time.

 :spank:

Offline TheQ

  • Website Content Manager
  • MOC Lifetime Member
  • *
  • Posts: 4263
    • Michigan Open Carry, Inc.
  • First Name (Displayed): Phillip
Hey, you software and website designer guys here
« Reply #10 on: March 21, 2014, 09:21:58 AM »

If someone uses an available feature during the hours of 9-5, how does that make the rest of the application unusable at all?

That's like saying you can't hit the break and turn the steering wheel at the same time.

 :spank:

Record locking?
I Am Not A Lawyer (nor a gunsmith).

Offline jgillmanjr

  • MOC Member
  • *
  • Posts: 654
    • Freedom Forged Security Consulting
  • First Name (Displayed): Jason
Re: Hey, you software and website designer guys here
« Reply #11 on: March 21, 2014, 04:17:59 PM »
Quote
The owner of the Silencer Shop is calling shenanigans on that claim. According to him, forms are only being batch uploaded between the hours of 4 and 5 AM, at the rate of about four every minute.

Four a minute and that's hosing the system?

More amateur hour $#|t from the government IT crew (or whoever the hell they contracted it out to)...
IT Director
Deputy Treasurer
Legislative Aide

Offline gryphon

  • Administrator
  • *****
  • Posts: 4037
  • First Name (Displayed): Dan
Re: Hey, you software and website designer guys here
« Reply #12 on: March 21, 2014, 05:02:15 PM »
Record locking?

Record locking would be the thing to do.  Database locking, on the other hand, is amateur hour!

Offline jgillmanjr

  • MOC Member
  • *
  • Posts: 654
    • Freedom Forged Security Consulting
  • First Name (Displayed): Jason
Re: Hey, you software and website designer guys here
« Reply #13 on: March 21, 2014, 09:35:31 PM »
Record locking would be the thing to do.  Database locking, on the other hand, is amateur hour!

Row level write locks or GTFO.

Seriously, there's probably a reason MySQL uses InnoDB as the default engine now.
IT Director
Deputy Treasurer
Legislative Aide

Offline gryphon

  • Administrator
  • *****
  • Posts: 4037
  • First Name (Displayed): Dan
Re: Hey, you software and website designer guys here
« Reply #14 on: March 21, 2014, 10:37:56 PM »
Well, my point was you only need to lock the record you are processing, not the entire database.  So, if only the Danny Griffin record is locked, Jason Gillman should still be able to enter his record in the database.  The entire database shouldn't be unavailable just because one record is being processed.

Offline jgillmanjr

  • MOC Member
  • *
  • Posts: 654
    • Freedom Forged Security Consulting
  • First Name (Displayed): Jason
Re: Hey, you software and website designer guys here
« Reply #15 on: March 21, 2014, 10:52:27 PM »
Well, my point was you only need to lock the record you are processing, not the entire database.  So, if only the Danny Griffin record is locked, Jason Gillman should still be able to enter his record in the database.  The entire database shouldn't be unavailable just because one record is being processed.

Yeah, that's pretty much row level write locks, as compared to table or larger locks.
IT Director
Deputy Treasurer
Legislative Aide

Offline gryphon

  • Administrator
  • *****
  • Posts: 4037
  • First Name (Displayed): Dan
Re: Hey, you software and website designer guys here
« Reply #16 on: March 21, 2014, 11:30:36 PM »
Yeah, I never dealt with these new-fangled databases like Oracle using SQL and stuff.  I used to write B/B+ trees for dedicated PC applications back in the stone age so that's what I am more familiar with.

Offline jgillmanjr

  • MOC Member
  • *
  • Posts: 654
    • Freedom Forged Security Consulting
  • First Name (Displayed): Jason
Re: Hey, you software and website designer guys here
« Reply #17 on: March 21, 2014, 11:58:09 PM »
Yeah, I never dealt with these new-fangled databases like Oracle using SQL and stuff.  I used to write B/B+ trees for dedicated PC applications back in the stone age so that's what I am more familiar with.

Heh, I'm pretty sure modern databases still use B-Trees ;)
IT Director
Deputy Treasurer
Legislative Aide

Offline linux203

  • MOC Member
  • *
  • Posts: 706
  • First Name (Displayed): Daniel
Re: Hey, you software and website designer guys here
« Reply #18 on: March 22, 2014, 11:27:34 AM »
I call BS.  I work on the front end of a pretty complex and busy system.  We accept batch processing.  Batch is processed on a different set of application servers behind a different set of web servers.  Lanes don't merge until the database layer.  Batch processing only affects batch processing.

If the claim of 1 per 15 seconds during off peak is accurate and causing performance issues in the day, it's bad application code.  They probably never researched the volume of paper flow multiplied by the number of transactions needed to submit a form, and the total resources required to process that form.  It's a niche system that is probably grossly underpowered.

When a strong man, fully armed, guards his own palace, his goods are in peace. Luke 11:21

Then He said to them, “But now, he who has a money bag, let him take it, and likewise a knapsack; and he who has no sword, let him sell his garment and buy one."  Luke 22:36

Offline gryphon

  • Administrator
  • *****
  • Posts: 4037
  • First Name (Displayed): Dan
Re: Hey, you software and website designer guys here
« Reply #19 on: March 22, 2014, 12:34:14 PM »
Don't know if any of you ever browse quora (a website where people pose and answer questions--don't, it's addictive) but here's a question I ran across today.

http://www.quora.com/Software/What-are-some-of-the-funniest-software-bugs-you-have-seen

 :threadjack: