|
You could just use any USB keypad, wire it through Prang Prang Once Again[^]
Modify the firmware to intercept keystrokes, and replace them with your own. That's probably what I would do.
To err is human. Fortune favors the monsters.
|
|
|
|
|
The sockets on my UPS and I assume all others are too close together to accommodate the use of multiple USB/AC Mains Plug adaptors inserted next to each other as these USB/AC Mains Plug adaptors are overly wide. Does anyone know of an adaptor which can be plugged into say a 9 (my USB) socket linear array of AC Mains sockets but which presents the same number only more widely spaced? I assume this is a common problem but did not find solution via web. Thank You Kindly
|
|
|
|
|
Here's your solution:
Short Extensions[^]
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Super Duper! Thank You Kindly I never would have thought of short extensions or even considered such existed May You Live Long and Prosper
modified 16-Oct-22 0:50am.
|
|
|
|
|
Glad I could help!
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
what always irritates me is how the a/c power strips have the blades in line with the strip, meaning a wall wart always consumes 2 slots. I know some of the a/c strips have sockets that rotate, but rotation almost doubles the price.
I'm looking down at my power strip with all of those extensions sticking out of it
Charlie Gilley
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Has never been more appropriate.
|
|
|
|
|
|
Why are dogs terrible dance partners?
They have two left feet.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Well, that makes you paws for thought.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
The celery was unacceptable so I did not turnip for work.
*hides*
To err is human. Fortune favors the monsters.
|
|
|
|
|
It won't help to stay in your root cellar; we WILL dig you out!
|
|
|
|
|
That pun was very corny...
|
|
|
|
|
Oh so bad but a good one too.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Abbott: Did you ever draw a nice fat salary?
Costello: No, but I sketched a skinny tomato.
|
|
|
|
|
lol, A&C are classic.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Not so much a programming question, but more of a what's your opinion / experience on the matter.
So, a customer of mine is importing CSV files through a website, hosted in Microsoft Azure.
The file typically has around 2000 to 2500 lines and 20 to 25 values per line (depending on the type of import).
However, something is currently very wrong in my software or database and more often than not my customer is greeted by a timeout error (well, a "something went wrong" message, because I do proper error handling ).
Last week, it took 17 tries to import one file.
The funny thing is, it ultimately works every time.
Of course it wasn't always like that, but the import table in Azure SQL has over 2 million records now and I need to validate for double records, calculate a couple of other fields for which I need additional data, create some grouped data, etc.
Since I've added some stuff in the past year it's gotten slower and slower.
Not so much an issue in my development environment, but apparently a bottleneck in production.
Good thing they're calling me now that it's out of control, rather than sooner when it was more manageable
Anyway, I've currently got it down to four to six seconds, which is still an eternity I think.
Inserting so many records into the database, as well as fetching a good amount, just takes some time, apparently.
I'm doing everything synchronously (well, async, but waiting) and I haven't checked indexes yet, so maybe I could get it a bit faster still.
Perhaps upgrading my database in Azure could help a bit to.
If I really wanted to, I could make it instant, handle everything async, and give the user live updates.
They've got like five imports a day, so it's not like these five seconds are that big of a deal.
Other than that the system is pretty fast and they're very satisfied
So, for my question, how long should such an action take, according to you?
Is five seconds alright and should I just show a "busy" message, or is five seconds completely unacceptable (considering the scenario)?
|
|
|
|
|
Sander Rossel wrote: Last week, it took 17 tries to import one file.
The funny thing is, it ultimately works every time.
Would dumping it into a blank temp table, then doing the work from there after it is all in make things better? I would not be concerned about 5 to 10 (or even more) seconds for something that takes a lot of background checking.
|
|
|
|
|
David O'Neil wrote: Would dumping it into a blank temp table, then doing the work from there after it is all in make things better? Yeah, something like that would be my "instant" solution.
The UX would be better, but the use case is that they import the file and then immediately work with the transformed data, so they'd be waiting for that in any case.
|
|
|
|
|
I wouldn't waste another minute on this. If one of my DABs was working on it I would redirect them. Find something that run 10,000 a day.
|
|
|
|
|
And if you were me, I'd be out of a job for such short-sightedness.
That they don't use it much does not mean it's not important.
One CSV can result in 16 invoices, no invoices no money...
Now 16 invoices, five times a day, equals 80 invoices and 80 invoices is enough to keep you busy for the day.
Uploading five files should take about five minutes, but right now it takes them half an hour or even longer, and that means other people are waiting too...
So yeah, I am going to "waste" minutes on this vital task that they perform every day and which doesn't work most of the time!
In fact, the client called me twice to tell me this is a top priority and should be fixed ASAP.
|
|
|
|
|
ha! Always keep the factory running! Always.
Charlie Gilley
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Has never been more appropriate.
|
|
|
|
|
You're consistently getting a timeout on the import? That is the problem that needs to be fixed.
From your description the upload worked until you added a lot of processing to the upload. Timeout errors can be fixed by changing the environment or changing the process. Since you probably can't change the environment, fix the process by segregating the upload (insert into temp table), and then process the file.
|
|
|
|
|
5 seconds is not terrible. If you really wanted to make it faster, you could try inserting it into a smaller table, and then merge those new records into the existing table with a background job?
To err is human. Fortune favors the monsters.
|
|
|
|
|
honey the codewitch wrote: If you really wanted to make it faster, you could try inserting it into a smaller table, and then merge those new records into the existing table with a background job? I'd rather insert the raw data and handle everything else in a background job.
The UX would be better, but the use case is that they import the file and then immediately work with the transformed data, so they'd be waiting for that in any case.
I'm not a fan of having the same table twice and using the one as some sort of staging for the other (if that's what you're suggesting).
|
|
|
|
|
Whenever dealing with a fragile system (ie the web, international WAN) I would eliminate it first. As others have said load the data into a temp table just to get it off the web, process the crap out of it and then dump it into the destination table in its final form.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|