Please log in or register. Registered visitors get fewer ads.
Forum index | Previous Thread | Next thread
'World Class' part 65689009738548143571475437 12:54 - Oct 5 with 916 viewsBlueBadger

https://uk.finance.yahoo.com/news/missing-coronavirus-tests-glitch-large-excel-s

Millions spunked away on it, and it's basically an Excel file..

I'm one of the people who was blamed for getting Paul Cook sacked. PM for the full post.
Poll: Do we still want KM to be our manager
Blog: From Despair to Where?

0
'World Class' part 65689009738548143571475437 on 13:04 - Oct 5 with 881 viewsOldsmoker

Large files that exceed their size limits were always a pain.........
.... in the 1980's!!!!!
Savvy Computer professionals (like me) soon came up with a workaround.
All those guys have been thrown on the out-of-work scrap heap 'cos they're over 50 and don't know nuffin about 'puters.
It's a personal grudge thing I have.

Don't believe a word I say. I'm only kidding. Or am I?
Poll: What mode is best?

1
'World Class' part 65689009738548143571475437 on 13:07 - Oct 5 with 876 viewsDanTheMan

Christ, I know some companies love doing automations through CSVs and Excel files but when you're talking about data that has to deal with millions and millions of rows, maybe it's time to move to a database. Could even get away with SQLite.

Poll: FM Parallel Game Week 1 (Fulham) - Available Team

2
'World Class' part 65689009738548143571475437 on 13:10 - Oct 5 with 863 viewsTangledupin_Blue

I wonder how many £millions we are paying to some Conservative MP's spouse's consultancy for this latest fukup.

Poll: Which Two Will Gain Automatic Promotion?

0
'World Class' part 65689009738548143571475437 on 13:15 - Oct 5 with 839 viewsStokieBlue

'World Class' part 65689009738548143571475437 on 13:07 - Oct 5 by DanTheMan

Christ, I know some companies love doing automations through CSVs and Excel files but when you're talking about data that has to deal with millions and millions of rows, maybe it's time to move to a database. Could even get away with SQLite.


It's very poor indeed.

As you say, it's trivial to do in SQLite and Python if you want to do things quickly, there is really no excuse for having an Excel sheet in that kind of process.

It shouldn't even be that though, it should just be done properly, what they are doing really isn't complex.

SB
0
'World Class' part 65689009738548143571475437 on 13:21 - Oct 5 with 814 viewsDanTheMan

'World Class' part 65689009738548143571475437 on 13:15 - Oct 5 by StokieBlue

It's very poor indeed.

As you say, it's trivial to do in SQLite and Python if you want to do things quickly, there is really no excuse for having an Excel sheet in that kind of process.

It shouldn't even be that though, it should just be done properly, what they are doing really isn't complex.

SB


Yeah, the more I think about this, the stupider this implementation is. It's not something that would have even crossed my mind.

If anything doing it through via files seems harder. I'm just astounded.

I'm sure I could reach this level of "efficiency" if I just made an absolute mess of everything I did.
[Post edited 5 Oct 2020 13:21]

Poll: FM Parallel Game Week 1 (Fulham) - Available Team

1
'World Class' part 65689009738548143571475437 on 14:35 - Oct 5 with 735 viewsSwansea_Blue

'World Class' part 65689009738548143571475437 on 13:21 - Oct 5 by DanTheMan

Yeah, the more I think about this, the stupider this implementation is. It's not something that would have even crossed my mind.

If anything doing it through via files seems harder. I'm just astounded.

I'm sure I could reach this level of "efficiency" if I just made an absolute mess of everything I did.
[Post edited 5 Oct 2020 13:21]


It's ok, they've got it cracked




This is what it would look like if I was doing it. Although it was reported in the Mail, so could well be wrong.

Poll: Do you think Pert is key to all of this?

0
'World Class' part 65689009738548143571475437 on 14:50 - Oct 5 with 715 viewsKeno

exclusive

UK Government buys new hardware to run mega important data stuff thing on

[Post edited 5 Oct 2020 14:50]

Poll: Best Superman - in view of the new film who’s the best
Blog: [Blog] My World Cup Reflections

1
'World Class' part 65689009738548143571475437 on 14:57 - Oct 5 with 693 viewseireblue

What is the word for a complete and utter shambolic clusterf*uck of epic proportions.

Then I need the word that describes something an order of magnitude worse.

Stick “world class” in front of that word.

Then we are getting close.
0
Login to get fewer ads

'World Class' part 65689009738548143571475437 on 16:50 - Oct 5 with 635 viewsJ2BLUE


Truly impaired.
Poll: Will you buying a Super Blues membership?

4
'World Class' part 65689009738548143571475437 on 18:09 - Oct 5 with 587 viewsPinewoodblue

'World Class' part 65689009738548143571475437 on 16:50 - Oct 5 by J2BLUE



Hope Starmer asked Johnson tomorrow what operating system they were running excel on. Anyone like to guess. I’ll go for Windows 95

2023 year of destiny
Poll: Dickhead "Noun" a stupid, irritating, or ridiculous man.

0
'World Class' part 65689009738548143571475437 on 20:14 - Oct 5 with 554 viewsSouthBucksBlue

Worse still it was the old (replaced in 2007) xls format and not the current xlsx format which would have been able to hold the full data.
Beggars belief.
1
'World Class' part 65689009738548143571475437 on 22:12 - Oct 5 with 522 viewsPinewoodblue

'World Class' part 65689009738548143571475437 on 20:14 - Oct 5 by SouthBucksBlue

Worse still it was the old (replaced in 2007) xls format and not the current xlsx format which would have been able to hold the full data.
Beggars belief.


And they still call it a glitch.

2023 year of destiny
Poll: Dickhead "Noun" a stupid, irritating, or ridiculous man.

0




About Us Contact Us Terms & Conditions Privacy Cookies Online Safety Advertising
© TWTD 1995-2025