Skip Navigation
Anyone having acceptable performance with SQL Server + odbc?
  • Been a little while since I worked on ODBC stuff, but I have a couple of thoughts:

    • Would it be possible to use something like a table function on the DB side to simplify the query from the ODBC side?

    • I could be misremembering, but I feel like looping through individual inserts with an open connection was faster than trying to submit data in bulk when inserting that much data in one shot. Might be worth doing a benchmark in a test DB and table to confirm.

    I know I was able to insert more than 50M rows in a manner of single digit hours, but unfortunately don't have access to that codebase anymore to double check the specifics.

  • Never tire of winning
  • Thank you for the detailed response!

    I see now that you were responding to the title and not the content of the post.

    To further round out my knowledge and understanding, could you please point me to additional information about Latinos moving further to the right, Harris' popularity, and polling data showing her well behind Trump in key states?

    I'm also curious to see examples of the American left refusing to acknowledge the potential of a second Trump term.

    Thanks again for helping me understand.

  • Never tire of winning
  • I'm not sure if I understand the points you are trying to make. Could you please elaborate? A) this meme is about records broken, not "wins." A president winning a second term would not break any records. B) why wouldn't Americans vote for a black woman? C) why would the thought of Americans electing a black women be "cult like?"

  • violently cries and sobs
  • I'm sorry, I hope I didn't offend you.

    I'm still not sure if I understand the intended joke. An average of 41 attempts per person sounds horrific. I'm sure there is something that's going over my head, it's some kind of dark humor, correct?

  • violently cries and sobs
  • I sincerely hope that she has been trending in a positive direction. I'm glad to hear that her attempts have been unsuccessful, and that she has good love, support, and (hopefully helpful) medication in her life.

    I imagine the knowledge of your sister struggling and suffering is hard on you too, and I wish the best for both of you.

  • violently cries and sobs
  • Thank you, I agree that it's an important distinction to make. Having only been able to read the abstract of the linked article, do you perhaps have any information on the number of completed attempts compared to unsuccessful attempts?

    I hope it goes without saying that even a single attempt is too many, and any completed attempts are devastating tragedies that don't reflect kindly on our current society.

  • violently cries and sobs
  • Is that referring to 41%, 41 per 1000, or some other metric entirely? Either way it's too damn high, but I'm curious and I don't know how to go about researching it without potentially making the almighty algorithm think I'm anti-trans.

  • What uses of a smartphone do you think most people miss out on?
  • Automation. My phone automatically triggers API calls, settings tweaks, launches apps to specific pages/playlists, and collects usage statistics to a local and private location all on its own. This means I only get a day and a half of battery life, but the tradeoff is well worth it in my opinion.

  • Is anyone else worried about the apple vision pro?
  • https://mashable.com/article/iphone-2g-original-naysayers

    https://forums.anandtech.com/threads/saw-this-on-reddit-tonight-a-2007-iphone-will-fail-column.2240010/ (can't seem to find the original article, so this is commentary and quotes from what the article said at the time)

    https://news.ycombinator.com/item?id=7419784 (additional quotes and commentary on the same Bloomberg article, with other similar articles mentioned)

    http://suckbusters2.blogspot.com/2007/06/apple-iphone-debut-to-flop-product-to.html?m=1 (good summary of the points that were made in opposition)

    Android was going to be very different before the iPhone was revealed. That moment very clearly ushered in a new era for smartphones and phone technology in general. Now smartphones weren't just for business people with an IT team for support, or wealthier and tech savvy individuals, they were for the masses. That undeniably changed the world (for better or worse), and there's no way anyone could have predicted the outcome with any confidence at the time.

    Perhaps Vision Pro will be a success and usher in a new revolution in technology, or perhaps it will only ever be a niche device, or maybe it flops altogether in a short amount of time. No one can say for sure how things will play out until it happens.

  • Is anyone else worried about the apple vision pro?
  • What if the person with the Vision Pro got it to help with a physical disability, and it has greatly improved their quality of life? Or what if it was gifted to them by a now passed friend or family member, and now holds a great deal of sentimental value to that individual? Do you not agree that criticizing in these (and likely many other) instances would be an asshole move on your part?

    You don't know how or why they obtained it, and their possession of it does not harm you in any way, shape, or form. Do you still not agree that being vocally and directly critical of the other person's simple possession of this item is an asshole move?

  • ***
  • I would define them as follows:

    • Declaration: This thing exists.
    • Definition: Here are the details for how this thing works.
    • Initialization: Assign the initial state to this thing.
    • Assignment: The value of this thing is now X.
  • She scolds me about not buying anything in the bar we hang at
  • Designated Driver, i.e. the person who won’t be drinking any alcohol so that they can safely (and legally) drive the rest of the group home. Mostly a US thing where driving is the primary means of transportation.

  • I’m playing Metroid Prime 2 and am a little stressed about the ammo. Would using an infinite ammo cheat ruin the game?
  • I feel like the ammo aspect is a big part of what makes the game challenging. Like others have said, you can always get more ammo by using the opposite beam (i.e. killing enemies with the light beam gives dark beam ammo and vice versa), and you can also use the charge beam for a free shot even with 0 ammo.

    All of that put together can lead to some of the most exciting boss battles where you're out or almost out of ammo but still have a chance to get the final blow in before they do. Infinite ammo wouldn't necessarily ruin the game overall in my opinion, exploring would still be fun and exciting. But it would certainly rob you of those exciting moments.

  • InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)AM
    aMockTie @beehaw.org
    Posts 0
    Comments 27