Soft Delete w/ Indexes vs No Soft Delete MySQL
Decided to do some benchmarking. Paranoia Gem w/ Rails.Β
Testing with index on [id, deleted_at]
Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β userΒ Β Β Β systemΒ Β Β Β Β totalΒ Β Β Β Β Β Β real Making 200,000 users CreateΒ Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β 183.400000Β Β 8.530000 191.930000 (236.699280) Read 10,000 users by id Read by idΒ Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β Β 5.120000Β Β 0.210000Β Β 5.330000 (Β 6.005039)












