On Mon, 31 Mar 2003 10:07:55 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote: > > The same query from the command line takes 0.02 seconds. A factor of > > 5,000 tells me I've made a stupid blunder somewhere, but I've read > > and reread the documentation and it all looks OK to me. > > > > During the 93 seconds the execute takes, start the mysql client in > another window and do a "show processlist" (or show full processlist) > and try to identify your client connection and what status it is in. > > Tim.
I started the perl script that implements the query, and then checked the state of the process. It spends the entire time in the state "Sending data". Since this is the server side, it's a little unclear to me who's sending what to whom. I tried a fetchrow_arrayref and fetchall_arrayref, and it doesn't affect the execute time. fetchall_arrayref fails with a 'no execute'. I tried a trace on the dbi handle, but I don't see anything in the output that would indicate why it takes so long. Any thoughts on where to search for a problem would be appreciated. Cheers Mike
