Re[2]: Performance problem with 4.0.18

2004-03-11 Thread Andrey Chernyh
VP Can you supply us with an example? Some explain plans to corroborate your VP reported slowness. Of course. Here is the query. It is big and ugly, I'm curently working on system optimization. But why the same query is good at one machine and bad at another? I've made some experiments and can

Re[2]: Performance problem with 4.0.18

2004-03-09 Thread Andrey Chernyh
VP Can you supply us with an example? Some explain plans to corroborate your VP reported slowness. Of course. Here is the query. It is big and ugly, I'm curently working on system optimization. But why the same query is good at one machine and bad at another? SELECT ... FROM positionReports p