/api/storage/volumes with svm.name filter slow when using with pagination | NetApp | Page 1

quartz plover May 25, 2023, 7:49 PM

#

I'm trying to get all volumes for a given SVM through the REST API but after the first call returns quickly the consecutive calls with start.uuid are significantly slower but only if I use the svm.name filter. Any idea why this would be happening?

Example:
<HOST>/api/storage/volumes?svm.name=xxx&max_records=10 takes less than a second
<HOST>/api/storage/volumes?start.uuid=x-y-z&svm.name=xxx&max_records=10 takes 30 and usually only returns 1 record

quartz plover May 25, 2023, 8:12 PM

#

Interestingly, after I added order_by=name everything returns as expected.

#

Actually, it seems to change the start field to name as well. It's start.name now instead of start.uuid.

opal solstice May 31, 2023, 9:47 PM

#

Any filtering you do on the API call will most likely slow it down. As you are requesting the API to do the filtering before it sends to your request. How many volumes you have as I can get them all in a single request at around 3K volumes.

quartz plover Jun 5, 2023, 2:50 PM

#

~4K volumes

#

As soon as I added order_by the additional calls return as fast as the first one.

#

But without it, it takes forever.

opal solstice Jun 6, 2023, 6:35 PM

#

whate version of ontap?

#/api/storage/volumes with svm.name filter slow when using with pagination