Hi listers,
Using MySQL 4.0.15-max-debug on Windows 2000, I am working with perlscripts.
When one of my program runs, I have an unexpected long time for one query which take at least 10 min (in the best case, but it stayed blocked most of the time) instead of 10 sec when the query is on the mysql command line (a SELECT query about 81000 lines).
The command SHOW PROCESSLIST shows that the state of that command is "Writing to net" ! I don't see what that means and how I can find a solution ?
Anybody can help me ?
Try
$sth->{"mysql_use_result"} = 1;
before
$sth->execute()
The problem, I think, is that your client system starts swapping hard while trying to allocate enough memory to store 81,000 rows.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
