|
I'll take just about any bet that VBA is still being used for a whole lot of "very critical" things.
|
|
|
|
|
So, what is D.Analysis?
How do we answer this question with zero parameters? For starters, what is the data being stored in? Personally, I think the DB is the first thing to consider. I've done some pretty heavy lifting using PostgreSQL and a few lines of C#. I'm out of touch with SQL server but I'd guess it has the same or more functionality.
I'd need to know the size of the data in both width and record count, as well as the ultimate goal of the analysis. I can't pre-spec a language with the question asked. If I had to, I'd go with the language you are most proficient with as learning a new language is probably not practical in the real world.
|
|
|
|
|
"Best" is quite subjective. Even applying the scientific method to get an answer is likely to yield multiple top results with differences to small to matter.
When asked within the whole of the software development life cycle (SDLC), there are other considerations in determining what is best for you, your team, and your project.
What language that you know, or can easily learn, has an efficient and relatively simple, repeatable, and programmatically configurable library for data access?
Of the answers to that question, which libraries offer (in the context of the SDLC and your project) the blend of simplicity, scalability, performance, and supportability?
For me, since I use .NET and C#, I use the SqlClient library for whatever DB I am working with, wrapped in a simple, straightforward data access layer that with transactional support and parameters to avoid SQL injection. I do not use Entity Framework for production apps, since it tends to have higher support costs as a project evolves after the first production release, can generate some awful SQL, and does not scale well, besides being slower for "real world" CRUD uses.
Other developers will have other preferences, based on what they know, what kind of projects they use, and level of experience in a broad range of projects with the tools they select. The right answer is what works best for the developers on the project to deliver a production app that works, that scales, that is reliable, and that has the lowest SDLC cost for updates and extensions as the app matures and changes over time.
I know that is not a simple answer, but our discipline is not a simple one, nor one with which we can be successful by using "cookie cutter" designs or following "recipes" as if we were simply assembling widgets.
To get to your question, having obtained the data, you can apply the same principles to what you use to analyze the data.
modified 21-Aug-23 10:34am.
|
|
|
|
|
Just split a big job into three main threads in Windows. The first of them took longer to run than the other two (on a 4 core processor). Unfortunately, I can't exactly qualify it without re-running the almost 8 hour jobs on my 3.2 GHz machine. But two of the threads completed about an hour or more before the first thread! The last two completed at roughly the same time, far before the first of them.
|
|
|
|
|
Could be a ton of reasons why, but assuming it's the same code in all three threads, keep in mind there is such a thing as processor affinity and thread affinity. The whole concept of parallelism is a mirage. Computers are just so fast at context switching it seems that way, but this concept is why they have thread scheduling, etc.
In theory it's a lot like preemptive multitasking in Windows, but it's on a hardware level and thus much, much quicker with less crap in the way. But, even with a multi-core CPU, something's gotta manage what gets ran.
At least that's how it was back in my multithreaded days before multi-core became the norm but hyperthreading was a thing. These days in JavaScript land, threads scare people.
Jeremy Falcon
|
|
|
|
|
Let us also not forget there's thousands of other threads running in Windows that your process has to share those four cores with.
|
|
|
|
|
Quote: into three main threads in Windows.
You like to say with that you created _three_ threads in your _one_ process?
If yes, don't be surpriced about your measurements.
My expercience with windows is: In case you like to gain full cpu, span the work over multiply processes, instead of multiply threads in one process
|
|
|
|
|
Every I/O is an interrupt.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
Did you also set your priority among threads?
Honestly, I find my best performance in C# using the Task Parallel Library[^], letting it decide threads versus tasks, priorities, etc.
|
|
|
|
|
Tell the kids it's "12345678" and see how long they take to work it out.
Hang on, I'll quickly try it: "2444666668888888" - yeah, works fine for me ...
"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!
|
|
|
|
|
|
#Worldle #575 2/6 (100%)
🟩🟩🟩🟩🟨↗️
🟩🟩🟩🟩🟩🎉
https://worldle.teuteuf.fr
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Not sure if other news outlets are running this story/challenge, but I'm sure there are some.
Riemann hypothesis: Unsolved math problem worth $1 million[^]
According to the article:
Quote: In 2000, the Riemann hypothesis was designated as a Millennium Problem, one of seven mathematical problems that are deemed to be crucial to increasing and disseminating mathematical knowledge.
Anyone who solves any one of the seven Millennium Problems is entitled to the million-dollar bounty.
|
|
|
|
|
What? That old thing again?
Edit:
The Riemann hypothesis is noteworthy for its appearance on the list of Hilbert problems, Smale's list, the list of Millennium Prize Problems, and even the Weil conjectures, in its geometric guise. Although it has been attacked by major mathematicians of our day, many experts believe that it will still be part of unsolved problems lists for many centuries. Hilbert himself declared: "If I were to awaken after having slept for a thousand years, my first question would be: Has the Riemann hypothesis been proved?"
(Wikipedia)
modified 19-Aug-23 21:28pm.
|
|
|
|
|
I'm just surprised that no one has solved any of these 7 math problems for $1 million. I mean, that's a lot of money, even in 2023.
7+ billion people on earth - there has to be someone smart enough to solve these problems. This challenge is 23+ years old now.
|
|
|
|
|
|
Deposit one penny in your account today...
|
|
|
|
|
42 was in 1900 and because of inflation it's 1528.45 today.
I win!
I don't think before I open my mouth, I like to be as surprised a everyone else.
PartsBin an Electronics Part Organizer - Release Version 1.1.0 JaxCoder.com
Latest Article: Simon Says, A Child's Game
|
|
|
|
|
|
Have heard that there're many unproved theorems proposed by the Indian mathematician Srinivasa Ramanujan. Not sure whether any of them have prizes for proving.
|
|
|
|
|
A deaf mute guy walks up to a foursome on the first hole, hands one of the players a card that says “I am a deaf mute, playing as a single, may I play through?”
The guy that gets the card is a total jerk, shakes his head no, and points the deaf mute to go back and wait his turn.
A few holes later the jerk is standing in the fairway and gets hit in the head by a golf ball.
In excruciating pain and pissed off, he turns around and sees the deaf mute holding up four fingers.
I don't think before I open my mouth, I like to be as surprised a everyone else.
PartsBin an Electronics Part Organizer - Release Version 1.1.0 JaxCoder.com
Latest Article: Simon Says, A Child's Game
|
|
|
|
|
Karma is a b1tch
Or the guy is very good at aiming
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
A pastor, a doctor and an engineer were waiting one morning for a particularly slow group of golfers. The engineer fumed, "What's with these guys? We must have been waiting for 15 minutes!"
The doctor chimed in, "I don't know, but I've never seen such ineptitude!"
The pastor said, "Hey, here comes the greenskeeper. Let's have a word with him."
"Hi George. Say, what's with that group ahead of us? They're rather slow, aren't they?"
The greenskeeper replied, "Oh, yes, that's a group of blind firefighters. They lost their sight saving our clubhouse from a fire last year, so we always let them play for free anytime."
The group was silent for a moment. The pastor said, "That's so sad. I think I will say a special prayer for them tonight."
The doctor said, "Good idea. And I'm going to contact my ophthalmologist buddy and see if there's anything he can do for them."
The engineer said, "Why can't these guys play at night?"
|
|
|
|
|
David O'Neil wrote: The engineer said, "Why can't these guys play at night?" exactly...
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Mike Hankey wrote: A deaf mute guy walks up to a foursome on the first hole Yeah, I had something completely different in mind than golf when I first read this.
Jeremy Falcon
|
|
|
|
|