This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
so when same query query executed second time , it goes a lot faster like 1.5 --> 0,05 sec (in client program like forinstance HeidiiSQL)
2. I'm executing this many times via browser refresh so SQL is allways the same (also the same as at 1), but timing (sql_execution_time) is allways the 'same' 1.5s + a bit more.
Like caching would not work.
Using prooxol connection pool manager