Show newer

@RedTechEngineer@neckbeard.xyz
So I guess mining Monero doesn't scale that well

girls like being choked because its a evolutionary memory of being hauled off by grugs who then DP'ed them in the cave.

@nosleep@neckbeard.xyz
Maybe that's why the medium range rigs pool has 17k members while the other pools have just a few

>be me
>try mining Monero
>join a pool marked medium range rigs (80-160H/s) because I assume miners always have the best shit
>check stats
>4.8KH/s

@lain
Yeah, better queries are obvious, but not something I'm going to fix.
I'm going to try it out, but first I gotta figure out how, because the code isn't setup for it.

@lain
Really? Mastodon has a connection for each Sidekiq thread.

It's not the main reason, but having more would help out. The main issue is that lot of queries take forever so they clog up the connections and make the entire instance freeze up.

@trinsec I originally went for those too, but they didn't work.

@trinsec Neither works, removing the space does nothing and using double quotes causes this error:
ERROR: column "drive_file.userId" does not exist
LINE 1: SELECT id, name, url FROM drive_file WHERE "drive_file.userI...

@trinsec Without ' ' it says
ERROR: column drive_file.userid does not exist
LINE 1: SELECT id, name, url FROM drive_file WHERE drive_file.userId...
^
HINT: Perhaps you meant to reference the column "drive_file.userId".

Can somebody please explain to me what is wrong with this query and what it gives me 0 rows

SELECT id, name, url FROM drive_file WHERE 'drive_file.userId ' LIKE '7tin655pe6'

Show older
Game Liberty Mastodon

Mainly gaming/nerd instance for people who value free speech. Everyone is welcome.