search

erikrikarddaniel / pfitmap

1 stars 0 forks source link

Can deleting old protein_counts be made quicker? #104

Closed erikrikarddaniel closed 10 years ago

erikrikarddaniel commented 10 years ago

Call direct SQL to delete rows. Add ON DELETE CASCADE to foreign key declarations?

erikrikarddaniel commented 10 years ago

Can't use truncate since only a subset is deleted. We'll have to live with this I suppose.

erikrikarddaniel commented 10 years ago

Yes. A lot of deletes are called by .destroy, one for each row.

erikrikarddaniel commented 10 years ago

Fixed, with raw SQL, in commit e64f3b352b338b7fe53d6ee47c521eb9b6788e49.