cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

about PurePath of Database

knakayama
Contributor

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


2 REPLIES 2

Hi

Here is the explanation for your question from documentation

HTH

Yos

ChadTurner
Leader

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.

-Chad