• 24 Posts
  • 170 Comments
Joined 2 years ago
cake
Cake day: September 6th, 2023

help-circle










  • Microsoft is a collection of fiefdoms, each led by a Lord (Product Manager) who drive projects which have two possible motivations: 1) promotion 2) bonus. Quality is not a factor and hasn’t been for decades. Cohesion? No. The lords sometimes fight amongst themselves. They serve the line go up. Everything is line go up. There is no bottom to the products. Line must go up



  • afk_strats@lemmy.worldtoProgramming@programming.devdatabase greenhorn
    link
    fedilink
    English
    arrow-up
    6
    ·
    edit-2
    2 months ago

    While I get that SO can be monstrously unhelpful, database optimization is a whole profession so I think we need a bit more to help

    A few directions we could go here: Post your SQL query. This could be a structure or query issue. Best case, we could do some query optimization. Also, have you looked into indexing?

    Where are your bottlenecks coming from? Is your server desined for a I/O intensive workload like databases. Sequential read speed is not a good metrix.

    What about concurrency? If this is is super read/write intensive, optimization could depend on where data is written while you’re reading


  • I get where you’re coming from. You could revisit the contributions you’ve made and the messages and replies you’ve received. The difference is that those ARE meaningful and hopefully in a good way. I think Reddit actively pushes the concept of karma because it’s an great engagement metric and they love that.

    My opinion is that Reddit is captured and driven to push engagement for advertising revenue at the expense of meaningful interaction. Lemmy is a platform where that engagement metric is only intrinsic to the individual. People are here because they want to have meaningful conversations? Maybe I’m dreaming