db
db copied to clipboard
Efficient select query
I've the following code:
https://github.com/argoproj/argo/blob/850669f7a04d2f5ba07ea9ef93012b10dd3bca89/persist/sqldb/workflow_archive.go#L46
This is very slow (taking 7 seconds to return). My hypothesizes that column workflow is very large (up to 1MB) and that the cost of transmitting 40 that from the database is just very costly.
Assuming my hypothesis is correct - is there a way to make sure that upper.db does not transfer data it does not need please?