• 0 Posts
  • 11 Comments
Joined 1 year ago
cake
Cake day: August 8th, 2023

help-circle



  • 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.