Re: [PERFORM] Same SQL, 104296ms of difference between 7.4.12 and

On Fri, 2006-04-07 at 15:31, Richard Huxton wrote: > Rafael Martinez Guerrero wrote: > > Hello > > > > I have a sql statement that takes 108489.780 ms with 8.0.7 in a > > RHEL4/amd64linux server with 2xAMD Opteron(tm) Processor 275 2.00GHz / > > 8GB RAM and only 4

[PERFORM] Same SQL, 104296ms of difference between 7.4.12 and 8.0.7

Hello I have a sql statement that takes 108489.780 ms with 8.0.7 in a RHEL4/amd64linux server with 2xAMD Opteron(tm) Processor 275 2.00GHz / 8GB RAM and only 4193.588 ms with 7.4.12 in a RHEL3/386linux server with 2xIntel(R) Xeon(TM) CPU 2.40GHz / 4GB RAM. Some information: - There is no IO when

[PERFORM] Help with optimizing a sql statement

Hello We are running an application via web that use a lot of time to perform some operations. We are trying to find out if some of the sql statements used are the reason of the slow speed. We have identified a sql that takes like 4-5000ms more than the second slowest sql in out test server. I ho