It’s how CPUs do floating point calculations. It’s not just javascript. Long story short, a float is stored in the format of one bit for the +/-, some bits for a base value (mantissa), and some bits for the exponent. As a result, some numbers aren’t quite representable exactly.
One thing to know about transactions is that they track data and then write it. It’s not the opening that slows it down. I have a question though, what is your source data? Do you have a big CSV for something? Can you do a db to db transfer instead? There’s another tool called the BCP utility.
Edit: SQL server/ssms have tools for doing migrations and batch imports
I’ve done a lot of work and no, that is not normal.
A few things: First - SQL server has tools for migrating data that’s pretty fast. SQL bulk copy can use some of these. Check to see if the built in db tools are better for this.
SQL bulk copy can handle way more than 15,000 records
Why are you wrapping a data dump in a transaction? That will slow things down for sure.
You generally shouldn’t be doing huge queries like that to where you’re nearing the parameter limit.
Can you share the code?
I’ve been using it for forever and also used it for DnD, based off of…what’s his name, one of the bigger DM guys on YT. It works great.
I’m using Obsidian for work since cloud note apps are blocked and I don’t like it as much. It works, but I’m not as wild about it.
One issue I recently had with one note is that I wanted to export a section to share on the web and wasn’t able to do it and the web interface doesn’t really let me do the management that I need. My work machine is my main one right now, so I’m stuck with what I’ve got. That all being said, aside from privacy, there isn’t really a direct reason to change.
But I’m not super wild that MS is reading my notes since I’ve also used it as a diary at points. I’ll have to figure that bit out later.
F# also does that
I’m so tired…
I’ll watch it
At least the code on the bottom is actual code and not just signatures
We’re evolving too!
Removed by mod
Removed by mod
Removed by mod
Removed by mod
Removed by mod
Removed by mod
Removed by mod
Removed by mod
Removed by mod
How do people in Japan think that 10% of the population is foreign!?
I guess Argentina makes a bit more sense - except that not many people are trying to get to Argentina. That sounds like Argentina though.