Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^6: [OT] MySQL recalibrating a sort-index

by LanX (Saint)
on Feb 17, 2018 at 10:03 UTC ( [id://1209379]=note: print w/replies, xml ) Need Help??


in reply to Re^5: [OT] MySQL recalibrating a sort-index
in thread [OT] MySQL recalibrating a sort-index

> Ah, you were looking for a DEFERRABLE CONSTRAINT, which postpones the constraint

Yeah this would be nice.

> I can't imagine MariaDB does not have this functionality ....

And no it doesn't.

https://stackoverflow.com/questions/5014700/in-mysql-can-i-defer-referential-integrity-checks-until-commit

Though REPLACE turns out to be a workaround, I'm glad that performance is no issue in my case.

Cheers Rolf
(addicted to the Perl Programming Language and ☆☆☆☆ :)
Wikisyntax for the Monastery

  • Comment on Re^6: [OT] MySQL recalibrating a sort-index

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1209379]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (4)
As of 2024-04-20 00:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found