db icon indicating copy to clipboard operation
db copied to clipboard

Efficient select query

Open alexec opened this issue 6 years ago • 0 comments

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?

alexec avatar Jan 07 '20 22:01 alexec