4 ms·
No, the data was necessary (though there are a stack of different optimisation strategies they could have pursued with varying trade offs). Fetch size is a sta
by cs02rm0 7y ago
No, the data was necessary (though there are a stack of different optimisation strategies they could have pursued with varying trade offs).
Fetch size is a standard JDBC parameter for tweaking the number of rows paged in a database query. The Sun/Oracle default was 10 rows and the app needed to retrieve thousands. So it would retrieve 10, process them, retrieve 10 more, etc. Which was minimal overhead on most networks, but on a network with high latency it meant there was perhaps a couple of seconds delay with each fetch.