Your explain analyze is showing an example that runs in less than 15ms, and your logs indicate queries taking 2-3 seconds. I am missing part of the picture here. Can you clarify?
- Please help to improve SELECT JOIN performance, EXPLAIN A... Alexander Farber
- Re: Please help to improve SELECT JOIN performance, ... Michael Lewis
- Re: Please help to improve SELECT JOIN performan... Alexander Farber
- Re: Please help to improve SELECT JOIN perfo... Peter J. Holzer
- Re: Please help to improve SELECT JOIN perfo... Michael Lewis
- Re: Please help to improve SELECT JOIN p... Peter J. Holzer
- Re: Please help to improve SELECT J... Alexander Farber
- Re: Please help to improve SELE... Alexander Farber
- Re: Please help to improve SELECT J... Michael Lewis
- Re: Please help to improve SELE... Peter J. Holzer
- Re: Please help to improve SELECT JOIN performance, ... Peter J. Holzer