Query Slow remotely versus locally?

[Mike Petit]

Hi folks -

I'm running Mysql 4 on Debian with a 2.6 kernel.

I connect to this server using Coldfusion 5 using the Merant mySQL driver. Performance is poor.

One thing I am noticing is that if I take a query from the slow queries log that run for, say, 13 seconds, and enter mysql from the command line and execute the query directly, it will run in more like 1 second. Why would there be such a differential for the same query?

Put another way, does the slow queries log record the time mySQL spends on the query, or does it add other delays such as network time into the calculation? I cannot figure out why the same query would run 10 times slower when submitted from a different server...ideas?

Thanks to all!