any ETA on deleteAll? I have 150k entries that nee...
# prisma-whats-newj
joar
06/20/2017, 11:53 AMany ETA on deleteAll? I have 150k entries that need deleting heh
a
agartha
06/20/2017, 12:02 PM@joar Open the schema, cut the type, apply changes, past the type, apply changes, all gone 😄
j
joar
06/20/2017, 12:03 PMHaha solid solution if it wasnt for the fact that i need to keep 25% of the data
a
agartha
06/20/2017, 12:03 PMwell, then it's not deleteAll, is it? 🙂
n
nilan
06/20/2017, 12:33 PM@joar is there a filter condition that matches the items you need to delete?
j
joar
06/20/2017, 3:29 PMYep! @nilan
n
nilan
06/20/2017, 3:38 PMyou could adjust this snippet: https://github.com/graphcool-examples/scripts/blob/master/delete-nodes/delete-nodes.js#L29-L37 and include the filter condition
j
joar
06/21/2017, 9:35 AMI was planning that but at a rate of 3 delete requests / second it would take me 30 days to complete the operation
a
agartha
06/21/2017, 9:36 AMThe script should be adapted for batch mutations
agartha
06/21/2017, 9:36 AMto send a set of delete mutations in one batch mutation to the server
j
joar
06/21/2017, 9:37 AMoh that’s a good idea @agartha !
a
agartha
06/21/2017, 10:03 AMBluebird.map already has concurrency built in
agartha
06/21/2017, 10:04 AMSo I would get 200 id's, create 8 batch mutations with 25 delete requests in them, fire those concurrent using the bluebird.map call (max. concurrency 8)
agartha
06/21/2017, 10:04 AMThat would get you the highest throughput