delphix / dxtoolkit

Scripts that remotely interact with Delphix engine APIs
Apache License 2.0
38 stars 32 forks source link

"28022024: [snappervdb option for dx_get_snapshots]" #238

Open pcollins63 opened 7 months ago

pcollins63 commented 7 months ago

Is your feature request related to a problem? Please describe.

When running dx_get_snapshots for a given name it often takes a long time to return the data especially if there are lots of snapshots for that vdb. This is true of whichever Delphix Engine the target is.

Describe the solution you'd like

Please add a -snappervdb option to the dx_get_snapshots command or something that improves the performance (see comment below about dx_get_db_env).

Describe alternatives you've considered I'm not aware of or haven't found a workaround to this issue.

The same problem previously existed with dx_get_db_env until a -snappervdb option was added which considerably improved the performance of that command

Additional context Add any other context or screenshots about the feature request here.

pioro commented 3 months ago

Hi,

dx_get_snapshot without any filter is running API to get all snapshots VDB per VDB and then it is running a timerange API for each snapshot. With -name dbname filter

dx_get_snapshots -d dxtest -debug -name oratest

it is calling API to get a list of snapshot for this one database only and then a API cal for each snapshot to list time range.

If you are interesting in list of snapshots only without time range - you can try this

dx_get_snapshots -d dxtest -debug -name oratest -notime

reagrds,