Hi I wanted to know how MySQL works in java using JConnector.
I was wondering how is the memory used for this matter, speciffically
I have one and only one statement CCON aand many result sets like
ST = Ccon.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
RS1 = St.executeQuery
a huge SELECT Query 1
RS2 = St.executeQuery
a huge SELECT
RSn = St.executeQuery
a huge SELECT Query n
So if I want to retireve all this queries and use them later, does all
te result sets are kept in memory?
what if I finish using RS1 and RS2 and i close them? Does the JVM free
memory when I close this result sets? is there any consideration I can
Do you know or have some tips to make great queries which are not
Thanks a lot