Skip to content

Instantly share code, notes, and snippets.

View shzdb's full-sized avatar

Shahzad Bin Shahjahan shzdb

3 followers · 3 following
  • Tridz
View GitHub Profile
@shzdb
shzdb / Incremental Dump.sql.md
Created June 9, 2025 10:28

First go:

Query: Sort: Last updated - From Jan 2024 To Nov 2024 -> Row 200K e (~5 sec)

Store the last_export timestamp & last_output as csv

Second go:

Query : Sort: Last updated - From last_export To now -> Row 20K (~40 millisec)

Store last_export timestampt & last_output + current_output(append) output : last_output + current_output as csv