The current sqlc GetInvoice query experiences incremental slowdowns during the migration of large invoice databases, primarily due to its complex predicate set. For this specific use case, a streamlined GetInvoiceByHash function provides a more efficient solution, maintaining near-constant lookup times even with extensive table sizes. |
||
|---|---|---|
| .. | ||
| amp_invoices.sql | ||
| invoice_events.sql | ||
| invoices.sql | ||
| migration.sql | ||