Hello,

I've an interesting situation where I could not understand why there is a big difference in term of performance.

Below is the query I run against a MySQL 4.1.8 database through a CGI script (not on Command line) and display the result on a browser

select *,date_format(dchgLastmodified, '%Y-%m%-%d %H:%i:%s') as tstamp from tcr_device_changes, tcr_devices, tcr_customers where devOwner in ('BE') AND dchgDevId = devId AND devCusId = cusId AND dchgDevId = 4180 AND dchgFieldNa me not like 'dev_r_Proviso%' AND dchgFieldName <> 'dev_r_SysDescr' ORDER BY dchgLastmodified DESC

Situation A:

MGM, NDB, MYSQLD are running on the same box

The result of the above query is nearly immediate.

Situation B:

MGM is running on machine1 NDB1, MYSQLD1 are running on machine2 NDB2, MYSQLD2 are running on machine3

The result back from the same query is after a while (+/-20 sec)

Could someone give me a hint on what could impair the performance.

Thanks in advance for your time.

Best regards,

Philong