• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL query Cache / Java

 
Miran Cvenkel
Ranch Hand
Posts: 202
2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1. I have

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


Any explanation ?
 
Miran Cvenkel
Ranch Hand
Posts: 202
2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
red part takes time. Should I change something in first line , or is that it ?

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic