Reply to aleksfelipe's tweet:
@aleksfelipe retrieve the newest record you’ll be deleting, then “delete from TABLE where PK <= NewestPK”
Aleks Felipe
@roytang my concern is doing 2 separate queries w/ the first 1 being an Nth record query. is this approach already (at least) near optimal?
Roy Tang
@aleksfelipe yes. :D
If you enjoyed my content for some reason, I'd love to hear from you! Here are some options:
- You can buy me a coffee!
- You can share or reply to this post on Twitter.
- You can write a reply on your own site and submit the URL as a webmention via the form below.
- Or you can just contact me!