Hi, I am doing some research on sockpuppets. I'm trying to use the SQL database to assist in building my dataset, but queries seem to take a long time.
For instance, this previous query ran in 196 seconds:
https://quarry.wmcloud.org/query/61732
Whereas my identical query has been going for over 9 hours:
https://quarry.wmcloud.org/query/83588
A previous instance was running over a week before I restarted it.
Am I doing something wrong, or are these running times typical?
On another note, I have been looking for complete SQL dumps to run my own instance so that I don't cause issues with excessive queries, however I can only find complete xml dumps (https://dumps.wikimedia.org/enwiki/20240601/).
Is there any way to get a full SQL dump (complete with article revision history)?
Thank you for your help.