topic about PurePath of Database in Open Q&A

about PurePath of Database

knakayama — Fri, 10 Dec 2021 06:28:20 GMT

Hello,

I have a question about PurePath screen.

I want to know the sources from which "Fetches" and "Rows returned" items are obtained.

Also About "Fetches" and "Rows returned" There are places where the value is 0 and blank.

Please tell me if you know about this difference.

Regards,

Kaori Nakayama

Re: about PurePath of Database

Yosi_Neuman — Tue, 21 Apr 2020 14:21:41 GMT

Here is the explanation for your question from documentation

HTH

Yos

Re: about PurePath of Database

ChadTurner — Tue, 21 Apr 2020 15:57:20 GMT

Per the support doc:

The Fetches column shows the number of database round trips per SQL execution. Because most database drivers page result sets, roundtrips are normally fetched in sets of Rows returned per fetch. Therefore, if a result set has 200 rows and you have a fetch size of 50 rows per fetch, it will take 4 fetches to get all the data. More fetches mean slower response time. However, having too large of a fetch size can also lead to poor memory usage and you typically wouldn't read an entire data set anyway.