Volodymyr Levytskyi wrote:I used mysql profiler as described here.
The thing I've noticed is that the first run took 0.242 and subsequent runs of the same query took 0.06 sec.
The first run is the most expensive and that's why my gui freezes!
Volodymyr Levytskyi wrote:I read article written by @Jeanne Boyarsky here.
It says that we can execute multiple selects at once using ; to separate sql queries.
Volodymyr Levytskyi wrote:My database(mysql) supports sending multiple select statements separated by semicolon.
I tried that query from command line and it resulted in two separate tables as expected.
Still it is hard to believe that it is not supported.
Where to find out if mysql jdbc driver supports multiple selects separated by semicolon or not?
I could not find this in documentation of mysql jdbc driver.