ResponseError. Reason: java.net.SocketTimeoutException, Response:
java.net.SocketTimeoutException
To be honest:
- If your request takes more than 0.5 secs there must be a design issue in your app
- If you want to download 10000 rows -> Dont' do that (except there is an acceptable reason which is not given in 99.99% of all cases)
- If you want do download MB's of data -> see #2
Good practice:
- if your request needs more than 0.5 (secs) there MUST be a design issue (bad db design, indexes wrong, etc)
- Only download what the USER can handle at one time (e.g. 50 rows max.)
- download more only if he/she REALLY NEEDS it
- if you need to download huge data use (s)ftp
- if it's a batch job (like to process 100.000 rows -> don't do that with an app, it's a server's job or B4J) -> even here: Only load 100 rows at one time!
My requests (millions of rows in a db) take about 0.05 secs MAX! so I always DECREASE the timeout to 2 secs (if something really goes wrong like bad internet connection)