Many thanks MySQL. Really a good way to implement a driver. Go fuck yourself.

Defaults can be changed :)

I have a solution for your mysql problems :

see if the application youre using/building/supporting runs on postgresql

if it does that then just apt/yum remove mysql let the application squirm in pain while you rebuild it into using postgresql

also i've got some nice little setup scripts for postgresql for bash that i could give you

Solution is quite simple. I added 2 parameters to the connection URL and it is working fine:

useCursorFetch=true&defaultFetchSize=1000

However I didn't expect that put all in memory is the default behavior.

@jespersh I can't modify the query or the code since it is performed by a third-party library.

@brano88 Yes, by a library that I need to use.

@brano88 PostgreSQL doesn't have this kind of problem.

@brano88 Hey, we are not on stackoverflow.com! ;) It's just a rant. That's library is a very special case and it needs to work in that way. I don't want to explain here the details.