Timeline for Setting Oracle size of row fetches higher makes my app slower?
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 26, 2014 at 23:21 | comment | added | Aprillion | @AdrianShum I guess so, but that would not be my assumption that Oracle is not pre-fetching. There might be a different setting for how many rows are pre-fetched regardless of the last fetch size, in which case you would want to set the fetch size to the same number... I don't have any insight into the Oracle internals though. | |
| Nov 21, 2014 at 2:20 | comment | added | Adrian Shum | Given that in most case, processing of results and fetching are synchronous, I am curious to know, between each fetching, is Oracle doing any work to prepare for subsequent fetches? If not, then it is simply like, 1st person only folds required number of papers that 3rd person ask for, and when 3rd person is cutting shape, 1st person just stand still without doing anything. Then apart from point 3 about TCP/IP throttling, setting a fetch size of 1000 is not going to be worse than 10. Is my understanding correct? | |
| Oct 3, 2014 at 9:42 | history | edited | nhahtdh | CC BY-SA 3.0 |
added 1 character in body
|
| Jan 21, 2013 at 13:23 | comment | added | Aprillion | @Sumedh too many variables, you need to do your own tuning for your project, en.wikipedia.org/wiki/Performance_tuning | |
| Jan 10, 2013 at 11:55 | comment | added | Sumedh | So what will be this typical throttle size, aka practical size of pipe? | |
| Feb 16, 2012 at 21:18 | comment | added | Aprillion | oh,, thanks for the award ;)) just a side note, i guess Oracle might precache the data that will be fetched next, so d) is not really an issue | |
| Feb 16, 2012 at 21:04 | history | bounty ended | daveslab | ||
| Feb 16, 2012 at 21:03 | vote | accept | daveslab | ||
| Feb 16, 2012 at 21:03 | comment | added | daveslab | Finally! This is by far the clearest explanation. Your analogy makes a ton of sense. Thank you. | |
| Feb 16, 2012 at 19:33 | history | answered | Aprillion | CC BY-SA 3.0 |