jeudi 30 novembre 2017

Mysql: How to optimize deleting thousands of rows

I have hundred thousand rows in my table and I want to delete with condition It took 15 min but still not done? It's just a plane table no related model. Its a chunk of almost 200k rows that I want to remove I need to specify which needed to remove so I need to use condition If I can just truncate. Is there any way to handle this, I'm using laravel

Details::where('file_name_belongs',$file_name)->delete();



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire