Delete/Cascade is slow

[erikd]

The delete/cascade operation is slow. Its main purpose is testing and debugging, but deleting 1 million rows can take 30 minutes or more.

Persistent issue: yesodweb/persistent#1113

[erikd]

Progress is being made: yesodweb/persistent#1121 (comment) .

[erikd]

The Persistent PR has been merged, but last time I checked, Esqueleto did not yet work with the new Persistent.

[PapaSwer]

How can I implement it in the cardano-db-sync ?

[erikd]

This is a library (Persistent/Esqueleto) issue, rather than a db-sync issue.

[PapaSwer]

Is there anyway to import the fixed library to work with cardano-db-sync?

[erikd]

I need to investigate that, but it is not at the top of my list if priorities.

Last time I tried, I was able to update Persistent but not able to update Esqueleto. I need to be able to update both.